MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 101 to 108 of 108 total results

« Previous
9
10
11
Next »

https://dev.mysql.com/doc/refman/5.7/en/show-columns.html

on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays ...

13.7.5.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.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. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER ...

13.7.5.29 SHOW PROCESSLIST Statement

https://dev.mysql.com/doc/refman/5.7/en/show-processlist.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. SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed ...

13.7.5.38 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/5.7/en/show-triggers.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. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS ...

13.7.5.39 SHOW VARIABLES Statement

https://dev.mysql.com/doc/refman/5.7/en/show-variables.html

SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...

26.4.3.21 The metrics View

https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html

This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...

26.4.2.1 The sys_config Table

https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html

set_time The timestamp of the most recent modification to the row. This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The ...

11.2.10 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/5.7/en/two-digit-years.html

For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 become 2000-2069. Date values with 2-digit years are ambiguous because the century is unknown.