Search Results
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/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-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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-field-count.html
The normal use of this function is when mysql_store_result() returned NULL (and thus you have no result set pointer). unsigned int mysql_field_count(MYSQL *mysql) Description Returns the number of columns for the most recent query on the connection. In this case, you can call mysql_field_count() to determine whether mysql_store_result() should have produced a nonempty ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-get-option.html
For MYSQL_OPT_MAX_ALLOWED_PACKET, it is possible to set a session or global maximum buffer size, depending on whether the mysql argument to mysql_options() is non-NULL or NULL, mysql_get_option() similarly returns the session or global value ... int ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-list-dbs.html
wild may contain the wildcard characters % or _, or may be a NULL pointer to match all databases. MYSQL_RES * mysql_list_dbs(MYSQL *mysql, const char *wild) Description Returns a result set consisting of database names on the server that match the ...