PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. and these potential issues to consider: If you make enumeration values that look like ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...