Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
CALL statements are unrolled (see ???TODO: add section about unrolling???), so that each statement executed by the stored procedure is logged separately. (If a stored procedure A invokes a stored procedure B, then B is unrolled recursively). It also ... The preliminary rules above, together with the principles for logging format, have been used to construct the following ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/using-sql.html
The following example uses a Session to call an SQL Stored Procedure on the specific node. In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
The following example uses a Session to call an SQL Stored Procedure on the specific node. In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string.
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if you have not already done so. To assign a password for the initial MySQL root account, use the following procedure. The ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create routine Context: Databases ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
To generate embedding for a file stored in your Amazon S3 bucket, connect to your DB System, create a database, and use the heatwave_load() stored procedure routine to load the file. You can learn more about the MySQL HeatWave GenAI in-database ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
The procedure for loading time zone tables is platform dependent and requires decision making by the DBA, so it cannot be done automatically. Placing the host name and user name together means that index lookup can be used, which improves ...