Search Results
https://dev.mysql.com/doc/internals/en/prepared-stored-reexecution.html
Features of MySQL 4.1 and 5.0 put a new demand on the execution process: prepared statements and stored routines need to reuse the same parsed tree to execute a query many times. Later this memory root will be denoted as the permanent memory root ...So far no easy mechanism that would allow query reexecution using the conventional query processing code has been ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
This topic provides information related to the SELECT statement clauses supported in MySQL HeatWave and describes how to use the GROUP BY and QUALIFY clauses to group or filter the processing results. SELECT STATEMENT Clauses The following SELECT ...Verify if the query is offloaded to MySQL HeatWave for ...
https://dev.mysql.com/doc/refman/8.4/en/deallocate-prepare.html
{DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it results ...
https://dev.mysql.com/doc/refman/8.4/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...Cursor declarations must appear before handler declarations and after variable and condition ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. Users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. (That is, the statement fails if dropping an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the SET_ANY_DEFINER ...It removes privilege rows for the account from all grant ...
https://dev.mysql.com/doc/refman/8.4/en/execute.html
EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with PREPARE, you execute it with an EXECUTE statement that refers to the prepared statement name. If the prepared statement contains any parameter markers, you must ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains ...file_name Sometimes you may want your script to display progress information to the ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. For example, to see events for the test ...It ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). Any user credentials that you specified in the START GROUP_REPLICATION statement when starting Group Replication on this member are removed from ...As ...