MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 111 to 120 of 199 total results

https://dev.mysql.com/doc/refman/8.0/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 ...

15.7.7.18 SHOW EVENTS Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

15.7.7.38 SHOW TABLE STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html

The output does not explicitly list the table default character set, but the collation name begins with the character set name. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but ...

15.7.7.40 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html

row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...

B.3.6.1 Problems with ALTER TABLE

https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html

If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...

15.1.1 Atomic Data Definition Statement Support

https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html

An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...

8.4.5.2 Installing or Uninstalling MySQL Enterprise Audit

https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html

This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise Audit”. For general information about ...

12.10.5 Baltic Character Sets

https://dev.mysql.com/doc/refman/8.0/en/charset-baltic-sets.html

cp1257 (Windows Baltic) collations: cp1257_bin cp1257_general_ci (default) cp1257_lithuanian_ci latin7 (ISO 8859-13 Baltic) collations: latin7_bin latin7_estonian_cs latin7_general_ci (default) latin7_general_cs . The Baltic character sets cover ...

12.9.1 The utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding)

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb4.html

The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...

Displaying 111 to 120 of 199 total results