https://dev.mysql.com/using-date.html
When a '0000-00-00' date is used through Connector/ODBC, it is automatically converted to NULL because ODBC cannot handle that kind of date. MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” This is in some cases ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/version-tokens-usage.html
Otherwise, an error occurs: mysql> SELECT version_tokens_lock_shared('lock1', 'lock2', 0); +-------------------------------------------------+ | version_tokens_lock_shared('lock1', 'lock2', 0) | +-------------------------------------------------+ | ... Before using Version Tokens, install it according to the instructions provided at Section 5.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/window-function-restrictions.html
The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or DELETE statements to update rows. Using such functions in a subquery of these statements (to select rows) is permitted. MySQL does not support these ...
https://dev.mysql.com/writing-semisynchronous-replication-plugins.html
This section describes how to write server-side semisynchronous replication plugins, using the example plugins found in the plugin/semisync directory of MySQL source distributions. That directory contains the source files for master and slave ...
https://dev.mysql.com/adding-replicaset-instances.html
When you have created a replica set you can use the ReplicaSet.addInstance() operation to add an instance as a read-only secondary replica of the current primary of the replica set. Therefore, the primary of the replica set must be reachable and ...
https://dev.mysql.com/c-api-binary-log-functions.html
The following sections provide detailed descriptions of the functions that enable reading the stream of replication events from a MySQL server binary log. The following simple example program demonstrates the binary log C API functions. Program ...
https://dev.mysql.com/c-api-multiple-queries.html
By default, mysql_query() and mysql_real_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...
https://dev.mysql.com/c-api-optional-metadata.html
For metadata-optional connections, the mysql_fetch_field(), mysql_fetch_field_direct(), and mysql_fetch_fields() functions return NULL when the resultset_metadata system variable is set to NONE. When a client executes a statement that produces a ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/charset-collation-implementations.html
Example: "U+0000 NULL" does not have a weight and is ignorable. MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one ...
