https://dev.mysql.com/create-event.html
It specifies that the event executes one time only at the date and time given by timestamp, which must include both the date and time, or must be an expression that resolves to a datetime value. You may use a value of either the DATETIME or ...
https://dev.mysql.com/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/point-in-time-recovery-positions.html
This can be done like so: shell> mysqlbinlog --start-datetime="2005-04-20 9:55:00" \ --stop-datetime="2005-04-20 10:05:00" \ /var/log/mysql/bin.123456 > /tmp/mysql_restore.sql This command creates a small text file in the /tmp directory that ...
https://dev.mysql.com/c-api-prepared-statement-date-handling.html
The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. For DATE, TIME, DATETIME, or TIMESTAMP values, set buffer_type to MYSQL_TYPE_DATE, ...The members of this structure are described in Section 28.7.9, “C API Prepared Statement Data ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/cast-functions.html
Table 12.14 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...
https://dev.mysql.com/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. --delay-key-write=ALL Don't flush key buffers between writes for any MyISAM table. Note If you do this, you should not access MyISAM tables from another program ...
https://dev.mysql.com/mysql-calendar.html
For this reason, dates prior to the cutover stored as MySQL DATE or DATETIME values must be adjusted to compensate for the difference. MySQL uses what is known as a proleptic Gregorian calendar. Every country that has switched from the Julian to ...
https://dev.mysql.com/optimizer-statistics.html
The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in ...
