PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.0/en/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 13.3.5, “The ENUM Type”, and Section 13.3.6, “The SET Type”. Unless strict mode is disabled (not recommended, but see ...The value cannot be the error value (that is, 0 or the empty ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and ...In ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/alter-table.html
Modifying the definition of an ENUM or SET column by adding new enumeration or set members to the end of the list of valid member values, as long as the storage size of the data type does not change. Adding members in the middle of the list causes ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/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 ...