https://dev.mysql.com/c-api-prepared-statement-data-structures.html
bool *is_null This member points to a bool variable that is true if a value is NULL, false if it is not NULL. Set that variable's value to true or false appropriately between executions to indicate whether the corresponding data value is NULL or NOT ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 13.2.10.2, “JOIN Syntax”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
https://dev.mysql.com/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/mysql-cluster-api-definition.html
AutoReconnect Table 22.199 This table provides type and value information for the AutoReconnect API node configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units boolean Default false Range true, false Restart Type N This ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/explain-output.html
Impossible HAVING (JSON property: message) The HAVING clause is always false and cannot select any rows. Impossible WHERE (JSON property: message) The WHERE clause is always false and cannot select any rows. Impossible WHERE noticed after reading ...
https://dev.mysql.com/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document is validates against the schema, and false if it is not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. Provided that these conditions are met: If the document ...
https://dev.mysql.com/server-system-variables.html
Boolean variables can be set at startup to the values ON, TRUE, OFF, and FALSE (not case sensitive), as well as 1 and 0. If false, XA transactions remain attached to the handling session as long as that session is alive, during which time no other ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/mysql-cluster-programs-ndbd.html
--foreground Property Value Command-Line Format --foreground Type Boolean Default Value FALSE Causes ndbd or ndbmtd to execute as a foreground process, primarily for debugging purposes. --initial Property Value Command-Line Format --initial Type ...
https://dev.mysql.com/mysql-cluster-shm-definition.html
Communications between NDB cluster nodes are normally handled using TCP/IP. The shared memory (SHM) transporter is distinguished by the fact that signals are transmitted by writing in memory rather than on a socket. The shared-memory transporter ...
https://dev.mysql.com/semijoins.html
NOT IN (SELECT ...)) IS NOT FALSE and its equivalent (... In MySQL 8.0.17 and later, the subquery can also be the argument to an expression modified by NOT, IS [NOT] TRUE, or IS [NOT] FALSE. A semijoin is a preparation-time transformation that ...