Search Results
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/glossary.html
Backups are further classified as hot, warm, or cold depending on how much they interfere with normal database operation. The performance and scalability of a database applications is influenced by on how quickly a database connection can be ...
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 ...It ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. TEMPORARY tables; ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Invocation Syntax There are in general three ways to use mysqldump—in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server—as shown here: mysqldump [options] db_name [tbl_name ...] ... The ...The mysqldump command can also generate output in CSV, other delimited text, or XML ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
A DROP DATABASE operation can drop tables that belong to a general tablespace but it cannot drop the tablespace, even if the operation drops all tables that belong to the tablespace. InnoDB Examples This example demonstrates how to drop an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
DROP USER does not automatically drop or invalidate databases or objects within them that the old user created. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value ...It removes privilege rows for the account from all grant ...
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/mysql-errors/8.4/en/server-error-reference.html
Drop the database first if you really want to replace an existing database, or add an IF NOT EXISTS clause to the CREATE DATABASE statement if to retain an existing database without having the statement produce an error. Error number: 3091; Symbol: ...ER_YES is used in the Code column for these messages in subsequent SHOW WARNINGS ... The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named function_name. (DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is ...It requires the DELETE privilege for the mysql system schema because it removes the row from the mysql.func system table that registers the ...