Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-procedure.html
DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). (DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for ...A ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3748; Symbol: ER_CLIENT_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR; SQLSTATE: HY000 Message: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE are not allowed inside a transaction or inside a ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE [FUNCTION|PROCEDURE]. ALTER and DROP statements for stored procedures and functions are also replicated. Where ...Can I print out a variable's value within a stored routine for debugging purposes? ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
To invoke a stored procedure, use the CALL statement (see Section 15.2.1, “CALL Statement”). This option is supported with both CREATE FUNCTION and CREATE PROCEDURE. Note Specifying a parameter as IN, OUT, or INOUT is valid only for a PROCEDURE.
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. The UNDO keyword must be specified to drop an undo tablespace. Only undo tablespaces created using CREATE UNDO TABLESPACE ...Space is not released back to the operating system as it is for file-per-table ...
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. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. Important When a database ...IF EXISTS is used to prevent an error from occurring if the database does not ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition definitions associated with the dropped table. DROP TABLE causes an implicit commit, except when used ...Be careful with this statement! For each table, it removes the table definition and all table ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
Renaming a table requires ALTER and DROP on the old table, ALTER, CREATE, and INSERT on the new table. Multiple ADD, ALTER, DROP, and CHANGE clauses are permitted in a single ALTER TABLE statement, separated by commas. For example, to drop multiple ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Dropping an index DROP INDEX name ON table; ALTER TABLE tbl_name DROP INDEX name; The table remains available for read and write operations while the index is being dropped. The DROP INDEX statement only finishes after all transactions that are ...