Search Results
https://dev.mysql.com/doc/refman/8.4/en/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 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37284176) Added missing checks for NULL input arguments in mle::validate() and validate_session_options(). Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
The difference between the two is that mysql_query() expects the query to be specified as a null-terminated string whereas mysql_real_query() expects a counted string. If the string contains binary data (which may include null bytes), you must use ... Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-encrypted-connections.html
A NULL return value indicates that encryption is not being used. A non-NULL return value indicates an encrypted connection and names the encryption cipher. This section describes how C applications use the C API capabilities for encrypted ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
name: The address of an array of character pointers, each pointing to a null-terminated string defining an attribute name. bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-eof.html
In this case, a NULL return from mysql_fetch_row() always means the end of the result set has been reached and it is unnecessary to call mysql_eof(). Because an error may occur on the connection during this process, a NULL return value from ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-error.html
const char * mysql_error(MYSQL *mysql) Description For the connection specified by mysql, mysql_error() returns a null-terminated string containing the error message for the most recently invoked API function that failed. If a function did not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-field-direct.html
For metadata-optional connections, this function returns NULL when the resultset_metadata system variable is set to NONE. MYSQL_FIELD * mysql_fetch_field_direct(MYSQL_RES *result, unsigned int fieldnr) Description Given a field number fieldnr for a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-fields.html
For metadata-optional connections, this function returns NULL when the resultset_metadata system variable is set to NONE. MYSQL_FIELD * mysql_fetch_fields(MYSQL_RES *result) Description Returns an array of all MYSQL_FIELD structures for a result ...