Search Results
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
END block is in scope only for the SQL statements following the handler declarations in the block. In the following example, handlers H1 and H2 are in scope for conditions raised by statements stmt1 and stmt2. For example, a statement could generate ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ... The scope of a local variable is the BEGIN ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
To remove them, use the DROP FUNCTION statement: DROP FUNCTION service_get_read_locks; DROP FUNCTION service_get_write_locks; DROP FUNCTION service_release_locks; Using the Locking Service Function Interface Before using the locking service ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
ndb_import handles this in the same manner as a LOAD DATA statement does. --fields-enclosed-by=char Command-Line Format --fields-enclosed-by=char Type String Default Value [none] This works in the same way as the FIELDS ENCLOSED BY option does for ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
The SQL statements used to grant and revoke privileges on NDB tables, databases containing such tables, and columns within such tables are identical in all respects with the GRANT and REVOKE statements used in connection with database objects ... In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. To change a table's ...There ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. The statement ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a statement produces different errors on the source and the replica, the replication SQL thread ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
On each server, execute the following statement: SET @@GLOBAL.enforce_gtid_consistency = WARN; Let the server run for a while with your normal workload and monitor the logs. On each server, execute this statement: SET ... This section describes how ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you cannot tell from the error log what the problem was, try the following techniques: Verify that the source has binary logging enabled by issuing a SHOW BINARY LOG STATUS statement. For example, --skip-replica-start prevents the replication ...