PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
For NOW(), the binary log includes the timestamp and replicates correctly. (You can consider the routine execution timestamp and random number seed as implicit inputs that are identical on the source and replica.) Several characteristics provide ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-usage-differences.html
Previously, it was possible to dump stored routine and event definitions together with their creation and modification timestamps, by dumping the proc and event tables. As of MySQL 9.7, those tables are not used, so it is not possible to dump ...
https://dev.mysql.com/doc/refman/9.7/en/docker-mysql-more-topics.html
A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are included. Warning Any software updates or installations users perform to the Docker container (including ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.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 following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST SHOW FULL ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...