Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. By default, mysql itself recognizes the semicolon as a statement ...For example, the following stored procedure has a body made up of a BEGIN ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
To set a global system variable, use a SET statement with the appropriate keyword. These privileges apply: To set a global system variable runtime value, use the SET GLOBAL statement, which requires the SYSTEM_VARIABLES_ADMIN privilege (or the ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-query.html
mysql_real_query() executes the SQL statement pointed to by stmt_str, a string length bytes long. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or \g. If multiple-statement execution has been ... int ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN, CHECK TABLE, and so forth). You need not call ... MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note mysql_store_result() is a synchronous ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ...Statements referencing such features, even if effectively ignored by NDB, must be syntactically and otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is not present, InnoDB processes SELECT COUNT(*) ...If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to grouping on all ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”. To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For InnoDB, DATA_LENGTH is the approximate amount of space allocated for the clustered index, in bytes. Specifically, it is the clustered index size, in pages, multiplied by the InnoDB page size. INDEX_LENGTH For MyISAM, INDEX_LENGTH is the length ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. If these are binary logs, you must edit the binary log index file ... This section lists known issues in recent versions of ...