PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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.6, “The ENUM Type”, and Section 13.3.7, “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/9.7/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/9.7/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/9.7/en/srjs-data-arguments.html
The server SQL mode can affect how an invalid JavaScript value is handled when attempting to insert it into an ENUM or SET column. Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 9.7, the maximum combined length of ENUM or SET column elements was 64K. In MySQL 9.7, the ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/load-data.html
LOAD DATA regards all input as strings, so you cannot use numeric values for ENUM or SET columns the way you can with INSERT statements. The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given.