https://dev.mysql.com/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 11.8, “Data Type Storage Requirements” for the storage requirements ...
https://dev.mysql.com/constraint-enum.html
ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 11.4.4, “The ENUM Type”, and Section 11.4.5, “The SET Type”. With strict mode enabled (see Section 5.1.11, “Server ...
https://dev.mysql.com/string-type-overview.html
Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and collation: CHARACTER SET specifies the character set. For the ENUM and SET data types, this does ...For additional information about properties and storage requirements of the string types, see Section 11.4, “String Types”, and Section 11.8, “Data Type Storage ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
If you use this column, define it as shown here: NDB$OP_TYPE ENUM('WRITE_ROW', 'UPDATE_ROW', 'DELETE_ROW', 'REFRESH_ROW', 'READ_ROW') NOT NULL The WRITE_ROW, UPDATE_ROW, and DELETE_ROW operation types represent user-initiated operations. This ...
https://dev.mysql.com/innodb-online-ddl-operations.html
Adding members in the middle of the list causes renumbering of existing members, which requires a table copy. Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index ...
https://dev.mysql.com/c-api-data-structures.html
(The BLOB_FLAG and TIMESTAMP_FLAG flags are unneeded.) ENUM and SET values are returned as strings. For these, check that the type value is MYSQL_TYPE_STRING and that the ENUM_FLAG or SET_FLAG flag is set in the flags value. Pass the type value to ... 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/example-foreign-keys.html
In MySQL, InnoDB tables support checking of foreign key constraints. See Chapter 15, The InnoDB Storage Engine, and Section 1.8.2.3, “Foreign Key Differences”. A foreign key constraint is not required merely to join two tables. It is extremely ...
https://dev.mysql.com/upgrade-prerequisites.html
There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Prior to MySQL 8.0, the maximum combined length of ENUM or SET column elements was 64K. In MySQL 8.0, the ...
https://dev.mysql.com/silent-column-changes.html
Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. For the ENUM and SET data types, this does not occur; they are created as declared. In some cases, MySQL silently changes column specifications ...
https://dev.mysql.com/storage-requirements.html
The size of an ENUM object is determined by the number of different enumeration values. One byte is used for enumerations with up to 255 possible values. Two bytes are used for enumerations having between 256 and 65,535 possible values. InnoDB ...
