PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
These files, one per database directory, contained database default character set attributes. ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. In ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
To address these messages, issue DROP TABLE statement to remove data about the missing table from the data dictionary. On the new MySQL instance, recreate the table in a database of the same name. mysql> ALTER TABLE sakila.actor DISCARD TABLESPACE; ... Information about table definitions is stored in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. For instructions on setting up the world_x schema, see Section 22.3.2, “Download and Import world_x Database”. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. For instructions on setting up the world_x schema, see Section 22.4.2, “Download and Import world_x Database”. The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Nonetheless, most advanced database management systems have evolved some means of determining the physical location to be used for storing specific pieces of data in terms of the file system, hardware or even both. However, there is nothing ... This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
(If events access these tables explicitly for other purposes, you must grant the appropriate privileges on the tables.) Applying a binary log Table_map_log_event, which provides table metadata but does not make any database changes. It is ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Upgrade Procedure With Table Repair Or Rebuild Some upgrades may require that you drop and re-create database objects when you move from one MySQL series to the next. Perform any table repair or rebuilding operations needed to re-create database ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. Name locking is used for operations such as dropping or renaming ... SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. ALTER FUNCTION func_name [characteristic ...] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. ALTER PROCEDURE proc_name [characteristic ...] ...