PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/flow-control-functions.html
If all types are temporal, the result is temporal: If all temporal types are DATE, TIME, or TIMESTAMP, the result is DATE, TIME, or TIMESTAMP, respectively. Otherwise, for a mix of temporal types, the result is DATETIME. The second syntax returns ...
https://dev.mysql.com/doc/refman/9.7/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-libraries-table.html
LAST_ALTERED Most recent date and time that the library was altered. This is a set consisting of none or any one or more of the following: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, ONLY_FULL_GROUP_BY, NO_UNSIGNED_SUBTRACTION, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. LAST_ALTERED The date and time when the routine was last modified. The ROUTINES table provides information about stored routines (stored procedures and ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-page-compression.html
During recovery, updated pages are written out in an uncompressed form. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... INSERT with an ON DUPLICATE KEY UPDATE clause enables existing rows to be updated if a row to be ...
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-plugin.html
For example: STANDBY_SERVER=host_ip:port_num,host_ip:port_num,host_ip:port_num,host_ip:port_num Ensure that the list of standby servers is kept short, accurate, and up to date, and servers that are no longer valid are removed. For example: ... Note ...
https://dev.mysql.com/doc/refman/9.7/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral derived tables are ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. This may be updated after a table is loaded (or greatly changed) with myisamchk -a. If this is not updated at all, ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...