https://dev.mysql.com/windows-pluggable-authentication.html
Leading and trailing spaces not inside double quotation marks are ignored. Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an ...
https://dev.mysql.com/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/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/key-space.html
Space compression makes the index file smaller than the worst-case figure if a string column has a lot of trailing space or is a VARCHAR column that is not always used to the full length. You can roughly calculate the size for the index file as ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/set.html
Trailing spaces are automatically deleted from SET member values in the table definition when a table is created. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified ...
https://dev.mysql.com/precision-math-expressions.html
A string that begins with a number can be converted, but the trailing nonnumeric portion is truncated. With precision math, exact-value numbers are used as given whenever possible. For example, numbers in comparisons are used exactly as given ...
https://dev.mysql.com/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/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/load-data.html
INTO Syntax”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of the FIELDS and LINES clauses is the same for both statements. You can also load data files by using the ...
