PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The MySQL process list indicates the operations currently being performed by the set of threads ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. To see information about a table's triggers, you must have the TRIGGER privilege ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
InnoDB monitor output begins with a header containing a timestamp and the monitor name. When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. The following limitations apply to online DDL operations: The table is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.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/5.7/en/json.html
If two values originally come from the MySQL DATETIME and TIMESTAMP types, respectively, they are equal if they represent the same point in time. The JSON data type provides these advantages over storing JSON-format strings in a string column: ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...