https://dev.mysql.com/c-api-data-structures.html
(You cannot treat these as null-terminated strings if field values may contain binary data, because such values may contain null bytes internally.) Rows are obtained by calling mysql_fetch_row(). char * name The name of the field, as a ... This ...
https://dev.mysql.com/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/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/mysql-nutshell.html
Either function produces an error if its (non-null) argument cannot be parsed as a valid JSON document, and NULL if the argument is NULL. Each member of the second object for which there is no member having the same key in the first object, and ...
https://dev.mysql.com/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/replication-options-master.html
This section describes the server options and system variables that you can use on replication master servers. You can specify the options either on the command line or in an option file. On the master and each slave, you must use the server-id ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/mysqldump.html
NULL, 'NULL', and Empty Values: For a column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished from one another in the output generated by this option as follows. Value: XML Representation: NULL ...
https://dev.mysql.com/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. row ... This ...
https://dev.mysql.com/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 ... Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed but not the accompanying audit tables and UDFs needed for rule-based ...
