Search Results
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
All the types are defined within the include/mysql_com.h file within the enum_field_types enumerated structure. Example: a SET('A','B','C') column containing 'A' looks like: 01 -- (length = 1, value = 'A') ENUM Storage: one byte if less than 256 ...
https://dev.mysql.com/doc/internals/en/store-lock.html
Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); THD * thd ; THR_LOCK_DATA ** to ; enum thr_lock_type lock_type ; Description This is the store_lock method. */ THR_LOCK_DATA **ha_archive::store_lock(THD *thd, THR_LOCK_DATA **to, ...The idea with handler::store_lock() is the following: The statement decided which locks we should need for the table for updates/deletes/inserts we get WRITE locks, for ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjdatastoreexception-classification.html
Table 4.6 lookup(int) Parameter Description value the classification returned by getClassification() return the Classification for the error .
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-24.html
(WL #14426) Bugs Fixed Setting PAD_SPACE=1 did not cause CHAR columns to be padded with spaces to their full length, which prevented the MSSQL linked server from working with ENUM and CHAR columns in the MySQL Database. (Bug #32079486) ... Security ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM values. CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
UNION ALL queries with an ORDER BY or LIMIT clause, between dictionary-encoded columns, or between ENUM columns. EXCEPT, EXCEPT ALL, INTERSECT, INTERSECT ALL, and UNION queries with or without an ORDER BY or LIMIT clause, between dictionary-encoded ...For a list of supported SQL modes, see Section 5.2, “Supported SQL ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
For SET or ENUM values, the cast operation causes the underlying numeric value to be used. mysql> SELECT student_name, MIN(test_score), MAX(test_score) FROM student GROUP BY student_name; For MAX(), MySQL currently compares ENUM and SET columns by ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.
https://dev.mysql.com/doc/refman/8.4/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 ...