https://dev.mysql.com/delete.html
where_condition is an expression that evaluates to true for each row to be deleted. For example, DELETE FROM t PARTITION (p0) WHERE c < 5 deletes rows only from partition p0 for which the condition c < 5 is true; rows in any other partitions are not ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...
https://dev.mysql.com/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/gtid-functions.html
Table 12.23 GTID Functions Name Description GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. GTID_SUBSET(set1,set2) Given two sets of global transaction identifiers set1 and set2, returns true if all GTIDs in set1 ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/host-cache.html
If that is successful, the host name is updated with the resolved host name and the validation flag is set to true. For permanent failures, the host name remains NULL and the validation flag is set to true. The MySQL server maintains a host cache ...
https://dev.mysql.com/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/identifier-case-sensitivity.html
That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. It is not true for names of columns, constraints, databases, partitions, statements prepared ...
https://dev.mysql.com/index-statistics.html
However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 is not true when expr1 or expr2 (or both) are NULL. This affects ref accesses for comparisons of the form tbl_name.key = expr: MySQL will not access ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/innodb-auto-increment-handling.html
This result is true whether or not there are concurrently executing “INSERT-like” statements (of any type). This result is true whether or not there are concurrently executing “INSERT-like” statements (of any type). InnoDB provides a ...
https://dev.mysql.com/keywords.html
This may also be true for the names of built-in functions. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as ...
