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-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-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/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/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/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/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/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.0/en/innodb-online-ddl-operations.html
The temporary table comprising the new clustered index is renamed with the name of the original table, and the original table is dropped from the database. Dropping an index DROP INDEX name ON table; ALTER TABLE tbl_name DROP INDEX name; The table ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
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 ...