PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
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/correlated-subqueries.html
WHERE column1 = ANY (SELECT column1 FROM t2) would be TRUE, but in this example, the WHERE clause within the subquery is FALSE (because (5,6) is not equal to (5,7)), so the expression as a whole is FALSE. A correlated subquery is a subquery that ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-function-reference.html
Table 8.56 MySQL Enterprise Data Masking Component Functions Name Description current_role_in() Returns true if any active role matches an authorization ID in the list current_user_in() Returns true if the current user matches an authorization ID ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/9.7/en/declare-handler.html
This is true even if the condition occurs in an inner block. statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/events-privileges.html
The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can verify that this is true by examining the Information Schema EVENTS table before and after issuing ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
For example, if the profile was in PROTECTING mode, that is no longer true after calling sp_reload_firewall_group_rules() and you must set it to PROTECTING again explicitly. Purpose: Provide an application-level firewall enabling the database ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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 an in-memory ...
https://dev.mysql.com/doc/refman/9.7/en/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* ...