PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/glossary.html
These terms are commonly used in information about the MySQL database server. These properties are all desirable in a database system, and are all closely tied to the notion of a transaction. When a transaction makes multiple changes to the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--add-drop-database Command-Line Format --add-drop-database Write a DROP DATABASE statement before each CREATE DATABASE statement. If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--add-drop-database Command-Line Format --add-drop-database Write a DROP DATABASE statement before each CREATE DATABASE statement. If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped ... The ...The mysqldump command can also generate output in CSV, other delimited text, or XML ...
https://dev.mysql.com/doc/refman/8.0/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.0/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. DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] ...ENGINE sets the storage engine that uses the tablespace, where engine_name is the name of the storage ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...