Rechercher dans le manuel MySQL
Search Results
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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-false-p-3.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
