Search Results
https://dev.mysql.com/doc/refman/26.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/26.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/26.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/26.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/26.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 26.7 the interface for writing ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Index Yes Yes Yes Yes Information Schema Yes No Yes Yes Object Names Case Sensitivity Depends on collation Depends on collation Mixed Mixed MySQL: sensitivity of database, table, and trigger names OS dependent; other object names are not ... The ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Value is three 2-byte unsigned integers representing the character_set_client, collation_connection, and collation_server system variables. Value is a 2-byte unsigned integer representing the collation_database system variable. The character set ...
https://dev.mysql.com/doc/internals/en/miscellaneous-options.html
For Autotools MySQL build options that have CMake equivalents, the normal mapping from an Autotools option to the CMake option is to convert uppercase, remove leading dashes, replace dashes with underscores, and add a leading -D.
https://dev.mysql.com/doc/internals/en/query-event.html
Note only written if code > 0 (aka "en_US") Q_CHARSET_DATABASE_CODE characterset and collation of the schema Q_TABLE_MAP_FOR_UPDATE_CODE a 64bit-field ... Binlog::QUERY_EVENT: The query event is used to send text querys right the binlog.
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-26-7.html
This section provides information about keywords and reserved words in MySQL 26.7. MySQL 26.7 Keywords and Reserved Words MySQL 26.7 New Keywords and Reserved Words MySQL 26.7 Removed Keywords and Reserved Words MySQL 26.7 Keywords and Reserved ...