MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 131 to 140 of 140 total results

« Previous
12
13
14
Next »

https://dev.mysql.com/doc/refman/9.7/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.14 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/9.7/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.33 SHOW PROCESSLIST Statement

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

15.7.7.42 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/9.7/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.43 SHOW VARIABLES Statement

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

27.3.6.10 Stored Routine API

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html

Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...

30.4.3.21 The metrics View

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

30.4.2.1 The sys_config Table

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

13.2.9 2-Digit Years in Dates

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

14.20.2 Window Function Concepts and Syntax

https://dev.mysql.com/doc/refman/9.7/en/window-functions-usage.html

For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...

Displaying 131 to 140 of 140 total results

« Previous
12
13
14
Next »