MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 132 total results

https://dev.mysql.com/doc/refman/8.0/en/server-system-variable-reference.html

The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...

15.7.7.5 SHOW COLUMNS Statement

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

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

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER ...

15.7.7.29 SHOW PROCESSLIST Statement

https://dev.mysql.com/doc/refman/8.0/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 Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is ...

15.7.7.40 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html

This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...

15.7.7.41 SHOW VARIABLES Statement

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

SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). System variable information is also available from these sources: ...

30.4.3.21 The metrics View

https://dev.mysql.com/doc/refman/8.0/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 ...

30.4.2.1 The sys_config Table

https://dev.mysql.com/doc/refman/8.0/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 ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/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.

3.6 Preparing Your Installation for Upgrade

https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

In-place upgrade to MySQL 8.0 is not supported if tables contain old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). Before upgrading to the latest MySQL 8.0 release, ...

Displaying 121 to 130 of 132 total results