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/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
DROP Enables use of statements that drop (remove) existing databases, tables, and views. This also means that database objects created by users with the SYSTEM_USER privilege cannot be modified or dropped by users without the privilege. DROP for the ...These privileges are global because they are not specific to a particular ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-operations.html
mysql-js> db.getCollections() [ <Collection:countryinfo>, <Collection:flags> ] Drop a Collection To drop an existing collection from a schema, use the db object's dropCollection() method. For example, to drop the flags collection from the current ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
mysql-js> db.countryinfo.createIndex("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": true}], "unique": true}) Drop an Index To drop an index, pass the name of the index to drop to the dropIndex() method. For example, you can ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html
mysql-py> db.get_collections() [ <Collection:countryinfo>, <Collection:flags> ] Drop a Collection To drop an existing collection from a schema, use the db object's drop_collection() method. For example, to drop the flags collection from the current ... In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
mysql-py> db.countryinfo.create_index("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": True}], "unique": True}) Drop an Index To drop an index, pass the name of the index to drop to the drop_index() method. For example, you ...
https://dev.mysql.com/doc/refman/8.0/en/sys-list-drop.html
Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
(The ALTER ROUTINE privilege is required to drop the routine.) The server also automatically drops those privileges from the creator when the routine is dropped. If automatic_sp_privileges is 0, the server does not automatically add or drop these ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
Important For statement-based logging, an exception is made in the rules just given for the CREATE DATABASE, ALTER DATABASE, and DROP DATABASE statements. In those cases, the database being created, altered, or dropped replaces the default database ...The database that is checked for a match depends on the binary log format of the statement that is being ... When evaluating replication options, the replica ...
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] ...