https://dev.mysql.com/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/show-character-set.html
SHOW CHARACTER SET [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 rows using more ...
https://dev.mysql.com/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 As of MySQL 8.0.16, MySQL implements CHECK ... SHOW ...
https://dev.mysql.com/adding-collation-unicode-uca.html
This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml file. It uses a subset of the Locale Data Markup Language (LDML) ...
https://dev.mysql.com/c-api-data-structures.html
unsigned int charsetnr An ID number that indicates the character set/collation pair for the field. In this case, charsetnr corresponds to the character set indicated by that variable. In this case, charsetnr corresponds to the character set of the ... This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
https://dev.mysql.com/cast-functions.html
If you omit CHARACTER SET charset_name, the resulting character set and collation are defined by the character_set_connection and collation_connection system variables that determine the default connection character set and collation (see Section ...
https://dev.mysql.com/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. See the CHARSET_INFO.txt file in the strings directory for additional information. For a character set named MYSYS, the file is named MYSET.xml. <map> ...
https://dev.mysql.com/column-count-limit.html
MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns ...
https://dev.mysql.com/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...
https://dev.mysql.com/create-table-foreign-keys.html
MySQL supports foreign keys, which let you cross-reference related data across tables, and foreign key constraints, which help keep this spread-out data consistent. The index_name value is ignored if there is already an explicitly defined index on ...
