Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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/internals/en/x-protocol-messages-messages.html
BYTES x x x GEOMETRY BYTES TIME TIME x DATE DATETIME x DATETIME DATETIME x YEAR UINT x x TIMESTAMP DATETIME x SET SET x ENUM ENUM x NULL BYTES BIT BIT x Note The SQL "NULL" value is sent as an empty field value in Row. BYTES, ENUM Note BYTES is used ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
If an error occurs with an ENUM argument, use a different data type. Error number: 1026; Symbol: HW_ER_UNSUPPORTED_AGG_OVER_ENUM Message: Aggregation over an ENUM column is not supported in, [%s]. Description: HeatWave does not support this ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
BOOL Enum None BOOL Fixed, Bytes Decimal TINYINT, SMALLINT, MEDIUMINT, INTEGER, INT, BIGINT Boolean None TINYINT, SMALLINT, MEDIUMINT, INTEGER, INT, BIGINT Int, Long None Attempts narrowing/widening conversion. TINYINT, SMALLINT, MEDIUMINT, INTEGER, ... Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different ...
https://dev.mysql.com/doc/refman/8.4/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.4/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/heatwave/en/mys-hw-limitations-data-types.html
CAST() COALESCE() CASE IF() NULLIF() ABS() CEILING() FLOOR() ROUND() TRUNCATE() GREATEST() LEAST() The following ENUM type columns are unsupported: ENUM type columns as part of a UNION, EXCEPT, EXCEPT ALL, INTERSECT, or INTERSECT ALL SELECT list or ...The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following: Arithmetic operators, see: Section 5.3.2, “Arithmetic ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Table 11.1 .frm File Header Section Offset Length Value Explanation 0000 1 fe Always 0001 1 01 Always 0002 1 09 FRM_VER (which is in include/mysql_version.h) +3 +test(create_info->varchar) 0003 1 09 See enum legacy_db_type in sql/handler.h. 2164 1 ... Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table ...
https://dev.mysql.com/doc/refman/8.4/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 ...