Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/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 like SHOW TABLES, but ...
https://dev.mysql.com/doc/refman/9.7/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, ...
https://dev.mysql.com/doc/connector-cpp/9.7/en/connector-cpp-apps-general-considerations.html
#if MYSQL_CONCPP_VERSION_NUMBER < 8000032 // this usage is OK; it compiles with 8.0.31 and all previous versions #endif When a Connector/C++ application that uses X DevAPI also uses the CharacterSet::utf8mb3 enumeration constant or any of the new ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-loadable-function.html
(xxx() is not even called for subsequent rows.) Loadable Function Character Set Handling By default, loadable functions take no account of the character set or collation of string arguments or return values. In MySQL 9.7 the interface for writing ...