PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/time.html
MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) precision. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large ...
https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html
The resulting value includes a trailing fractional seconds part if specified. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
To remove these bytes, use the TRIM() function: UPDATE t SET col1 = TRIM(TRAILING 0x00 FROM col1); Suppose that table t has a nonbinary column named col1 defined as CHAR(50) CHARACTER SET latin1 but you want to convert it to use utf8mb4 so that you ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese coded character set”, which is the official character set of the People's Republic of China (PRC).
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
With the compact family of rows formats, InnoDB allocates a variable amount of storage in the range of N to N × the maximum byte length of the character set for these columns by stripping trailing spaces. Design your tables to minimize their space ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
If a string column has a length of zero after trailing space removal, or a numeric column has a value of zero, it is marked in the bitmap and not saved to disk. Dynamic storage format is used if a MyISAM table contains any variable-length columns ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, TEXT). If you want to store these results, use a column ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM member values in the table definition when a table is created. An ENUM is a string object with a value chosen from a list of permitted values that are enumerated ...