PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context. CURTIME([fsp]) Returns the current time as a value in 'hh:mm:ss' or hhmmss format, depending on ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
INET_ATON(expr) Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian). INET_NTOA(expr) Given a numeric IPv4 network address ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
--auto-generate-sql-execute-number=N Command-Line Format --auto-generate-sql-execute-number=# Type Numeric Specify how many queries to generate automatically. --auto-generate-sql-load-type=type Command-Line Format --auto-generate-sql-load-type=type ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For numeric arguments, the variance and standard deviation functions return a DOUBLE value. (They convert the values to numbers, losing everything after the first nonnumeric character.) To work around this problem, convert to numeric units, perform ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. For example, prepend the table name, or the database name and the table name, before the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
System variables that take a numeric value can be specified as --var_name=value on the command line or as var_name=value in option files. innodb_adaptive_hash_index_parts Command-Line Format --innodb-adaptive-hash-index-parts=# System Variable ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--binlog-row-event-max-size=N Command-Line Format --binlog-row-event-max-size=# Type Numeric Default Value 4294967040 Minimum Value 256 Maximum Value 18446744073709547520 Specify the maximum size of a row-based binary log event, in bytes. The ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
Variables that have a type of “numeric” take a numeric value. Variables that are marked as “enumeration” normally should be set to one of the available values for the variable, but can also be set to the number that corresponds to the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
On high concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and numeric types (SMALLINT, TINYINT, ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() ...A leading 0b is case-sensitive and cannot be written as ...