PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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. The second syntax returns the result for the first condition that is true. If no comparison ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
For example, if an event is created using ON SCHEDULE AT CURRENT_TIMESTAMP + '1:6' DAY_HOUR, and the event was created at 2018-02-09 14:05:30, the value shown in this column would be '2018-02-10 20:05:30'. The EVENTS table provides information ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in (native) functions or loadable functions. The ROUTINES table has these columns: SPECIFIC_NAME The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The value is a 128-bit number represented as a utf8mb3 string of five hexadecimal numbers in aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee format: The first three numbers are generated from the low, middle, and high parts of a timestamp. The fourth number ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--tz-utc Command-Line Format --tz-utc Disabled by skip-tz-utc This option enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones. Without this option, TIMESTAMP columns are dumped and reloaded in the time zones ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--tz-utc Command-Line Format --tz-utc This option enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones. Without this option, TIMESTAMP columns are dumped and reloaded in the time zones local to the source and ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-binary-log-transaction-compression-stats-table.html
FIRST_TRANSACTION_TIMESTAMP The timestamp when the first transaction was written to the log. LAST_TRANSACTION_TIMESTAMP The timestamp when the most recent transaction was written to the log. This table shows statistical information for transaction ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage started. END_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage finished. Note The Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-status-table.html
BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning operation started. END_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning operation finished. Note The Performance ...