https://dev.mysql.com/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...
https://dev.mysql.com/command-line-options.html
(This is also true for system variables set within option files.) For options that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Program options specified on the command ...
https://dev.mysql.com/constraint-enum.html
An error occurs for values that do not satisfy these conditions: An ENUM value must be one of those listed in the column definition, or the internal numeric equivalent thereof. ENUM and SET columns provide an efficient way to define columns that ...
https://dev.mysql.com/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...
https://dev.mysql.com/data-types.html
MySQL supports a number of SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview of these data types, a more detailed ...
https://dev.mysql.com/date-and-time-literals.html
(The MySQL TIMESTAMP year range is 1970 to 2038.) String and Numeric Literals in Date and Time Context. Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and ...
https://dev.mysql.com/date-and-time-type-conversion.html
To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the following way: date_col = CAST(datetime_col AS DATE) Conversion of TIME and DATETIME values to numeric form (for example, by adding +0) ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/date-and-time-type-overview.html
(They convert the values to numbers, losing everything after the first nonnumeric character.) To work around this problem, convert to numeric units, perform the aggregate operation, and convert back to a temporal value. For additional information ...
https://dev.mysql.com/date-and-time-types.html
MySQL automatically converts a date or time value to a number if the value is used in a numeric context and vice versa. The date and time types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each temporal type has a ...
