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/show-privileges.html
row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create Context: ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
The character_set_database and collation_database system variables indicate the character set and collation of the default database. For example: mysql> charset koi8r Charset changed The charset command issues a SET NAMES statement, and also changes ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
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 ...