Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-trigger.html
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use ...
https://dev.mysql.com/doc/refman/8.4/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/iterate.html
ITERATE label ITERATE can appear only within LOOP, REPEAT, and WHILE statements. ITERATE means “start the loop again.” For an example, see Section 15.6.5.5, “LOOP Statement”.
https://dev.mysql.com/doc/refman/8.4/en/leave.html
LEAVE label This statement is used to exit the flow control construct that has the given label. If the label is for the outermost stored program block, LEAVE exits the program.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. IF EXISTS statements for stored programs (stored ...This ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
The statement permits these role specifiers: DEFAULT: Activate the account default roles. Note SET DEFAULT ROLE and SET ROLE DEFAULT are different statements: SET DEFAULT ROLE defines which account roles to activate by default within account ... SET ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump file is being reloaded. The statement prevents new GTIDs from being generated and assigned to ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
This statement is used as part of the procedure described in Section 15.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. SHOW BINARY LOGS Lists the binary log files on the server. SHOW BINARY LOGS ...
https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, ...The LIKE ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row ...