https://dev.mysql.com/routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in SQL functions or user-defined functions (UDFs). The ROUTINES table has these columns: SPECIFIC_NAME ...
https://dev.mysql.com/sql-mode.html
It does not apply TIMESTAMP columns, which always require a valid date. TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column having the ...
https://dev.mysql.com/statement-summary-tables.html
The events_statements_summary_by_digest table has these additional summary columns: FIRST_SEEN, LAST_SEEN Timestamps indicating when statements with the given digest value were first seen and most recently seen. QUERY_SAMPLE_SEEN A timestamp ... The ...
https://dev.mysql.com/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. When an operator is used with operands of different types, type conversion ...
https://dev.mysql.com/alter-event.html
ALTER EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY DO TRUNCATE TABLE myschema.mytable; Specify the options in an ALTER EVENT statement only for those characteristics that you want to change; omitted options keep their existing ...
https://dev.mysql.com/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, and DATETIME do not support parts of seconds (for example, from DATE_FORMAT()). When converting an integer to string, ZEROFILL is honored with prepared ...
https://dev.mysql.com/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) and the avoid_temporal_upgrade system variable is disabled.
https://dev.mysql.com/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/columns-table.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these ...
