Search Results
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/performance-schema-optimization.html
Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), available as of MySQL 8.0.23, enables defining attributes that apply to the next query sent to the server. For discussion of ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-field-direct.html
MYSQL_FIELD * mysql_fetch_field_direct(MYSQL_RES *result, unsigned int fieldnr) Description Given a field number fieldnr for a column within a result set, returns that column's field definition as a MYSQL_FIELD structure. Use this function to ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-row.html
MYSQL_ROW mysql_fetch_row(MYSQL_RES *result) Description Note mysql_fetch_row() is a synchronous function. Its asynchronous counterpart is mysql_fetch_row_nonblocking(), for use by applications that require asynchronous communication with the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. The string in the from argument is encoded in hexadecimal format, with each character ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open ...