PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. By default, both variables are NULL, in which case, no account filtering is done and auditing occurs for ... Important The audit_log plugin is deprecated, and is being replaced by the audit_log ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-reference.html
Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Each element in the returned array is an event represented as a JSON hash, with the exception that the last element may be a JSON null value to ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-functions.html
Return value: The masked string, or NULL if either margin is negative. Return value: The masked string, or NULL if either margin is negative. Return value: A random integer in the range from lower to upper, inclusive, or NULL if the upper argument ... The MySQL Enterprise Data Masking plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data Generation Plugin Functions Random Data Dictionary-Based Plugin Functions These functions support the single-byte latin1 character set for string arguments and return ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
If desired, you can clear the training account, and enable all group members to perform training in RECORDING mode, by calling set_firewall_group_mode_and_user() and passing NULL for the account name, as shown here: CALL ... Purpose: Provide an ...
https://dev.mysql.com/doc/refman/9.7/en/join.html
If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table. SELECT left_tbl.* FROM { OJ left_tbl LEFT OUTER JOIN right_tbl ON left_tbl.id = right_tbl.id } ...
https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html
Returns NULL if any argument is NULL or the path argument does not identify a value in the document. 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 ...
https://dev.mysql.com/doc/refman/9.7/en/range-optimization.html
AND key_partN cmp constN; Here, const1, const2, … are constants, cmp is one of the =, <=>, or IS NULL comparison operators, and the conditions cover all index parts. For a BTREE index, an interval might be usable for conditions combined with AND, ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...