MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 47 total results

https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

String types that are cast include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL server options and variables ...

15.2.9 LOAD DATA Statement

https://dev.mysql.com/doc/refman/8.0/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.

14.19.1 Aggregate Function Descriptions

https://dev.mysql.com/doc/refman/8.0/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 ...

15.1.20 CREATE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/create-table.html

Character data types (CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can include CHARACTER SET to specify the character set for the column. Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial data types are not permitted; columns that ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...

14.10 Cast Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html

row *************************** Table: new_table Create Table: CREATE TABLE `new_table` ( `c1` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci The cast functions are useful for sorting ENUM columns in lexical ...

12.3.5 Column Character Set and Collation

https://dev.mysql.com/doc/refman/8.0/en/charset-column.html

Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...

26.6 Restrictions and Limitations on Partitioning

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html

This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...

15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html

For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. By default, a ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

https://dev.mysql.com/doc/refman/8.0/en/myisampack.html

table-lookup The column had only a small number of different values, which were converted to an ENUM before Huffman compression. When the table is used later, the server reads into memory the information needed to decompress columns. This results in ...

13.6 Data Type Default Values

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

For string types other than ENUM, the default value is the empty string. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column.

Displaying 11 to 20 of 47 total results