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/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.
https://dev.mysql.com/doc/refman/9.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-fractional-seconds.html
MySQL 9.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format; namely, the TIME, DATETIME, and TIMESTAMP columns that lacked support for fractional seconds precision. [QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a ...
https://dev.mysql.com/doc/refman/9.7/en/checksum-table.html
For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 table is upgraded to MySQL 5.6, the checksum value may change. [QUICK | EXTENDED] CHECKSUM TABLE reports ...
https://dev.mysql.com/doc/refman/9.7/en/purge-binary-logs.html
PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS BEFORE ...The ...
https://dev.mysql.com/doc/refman/9.7/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-error-reporter.html
The archive is named ndb_error_report_YYYYMMDDhhmmss.tar.bz2, where YYYYMMDDhhmmss is a datetime string. ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems ...
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/json-search-functions.html
type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED DATE TIME DATETIME YEAR YEAR values of one or two digits are not supported. The functions in this section perform search or comparison operations on JSON values to ...