https://dev.mysql.com/expressions.html
For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. If you specify a value like '1:10', MySQL assumes that the days and hours parts are missing and the value represents ...
https://dev.mysql.com/date-and-time-functions.html
DATETIME if the first argument is a DATETIME (or TIMESTAMP) value, or if the first argument is a DATE and the unit value uses HOURS, MINUTES, or SECONDS. mysql> SELECT EXTRACT(YEAR FROM '2019-07-02'); -> 2019 mysql> SELECT EXTRACT(YEAR_MONTH FROM ...
https://dev.mysql.com/create-event.html
For example, “two minutes and ten seconds” can be expressed as + INTERVAL '2:10' MINUTE_SECOND. Similarly, you can express “every two weeks, beginning six hours and fifteen minutes from now” as EVERY 2 WEEK STARTS CURRENT_TIMESTAMP + ...
https://dev.mysql.com/date-and-time-literals.html
For example, '20070523091528' and '070523091528' are interpreted as '2007-05-23 09:15:28', but '071122129015' is illegal (it has a nonsensical minute part) and becomes '0000-00-00 00:00:00'. Similarly, for values specified as strings that include ...
https://dev.mysql.com/c-api-prepared-statement-data-structures.html
The hour, minute, and second elements are used for TIME, DATETIME, and TIMESTAMP values. Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer ...
https://dev.mysql.com/full-disk.html
Every 10 minutes it writes an entry to the log file, warning about the disk-full condition. The thread is aborted the next time it checks the disk (in one minute). This section describes how MySQL responds to disk-full errors (such as “no space ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/sys-statement-performance-analyzer.html
To create a report with the queries in the 95th percentile since the last truncation of events_statements_summary_by_digest and with a one-minute delta period: Create a temporary table to store the initial snapshot. Creates a report of the ...
https://dev.mysql.com/mysql-cluster-backup-using-management-client.html
Before starting a backup, make sure that the cluster is properly configured for performing one. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. If used, the backup_id must follow START ...
https://dev.mysql.com/replication-options-slave.html
This section explains the server options and system variables that apply to slave replication servers and contains the following: Startup Options for Replication Slaves Options for Logging Slave Status to Tables System Variables Used on Replication ...
