Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
mysqldump output can include ALTER DATABASE statements that change the database collation. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
row *************************** Table: accounts Non_unique: 0 Key_name: ACCOUNT Seq_in_index: 1 Column_name: USER Collation: NULL Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: HASH Comment: Index_comment: Visible: YES ...
https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. The WHERE clause can be given to select ...
https://dev.mysql.com/doc/refman/8.4/en/show-columns.html
The optional FULL keyword causes the output to include the column collation and comments, as well as the privileges you have for each column. Collation The collation for nonbinary string columns, or NULL for other columns. SHOW [EXTENDED] [FULL] ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
collation_connection is the session value of the collation_connection system variable when the event was created. Database Collation is the collation of the database with which the event is associated. SHOW CREATE EVENT event_name This statement ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SHOW CREATE TABLE displays ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: A Cardinality: 4188 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: Visible: YES Expression: NULL ...