PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
If the file name is a relative path name with leading components, the server looks for the file relative to its data directory. If the file name has no leading components, the server looks for the file in the database directory of the default ...The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior of such tables, and could easily lead to corruption or loss of data. In some cases, using large numbers (hundreds) of ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
Previously, MySQL supported arbitrary numbers of leading and trailing whitespace characters in date and time values, as well as between the date and time parts of DATETIME and TIMESTAMP values. Numbers that are not one of these lengths are ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
When an error in this range originates on the server side, the server writes it to the error log, padding the error code with leading zeros to six digits and adding a prefix of MY-. When an error in this range occurs, the server writes it to the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Otherwise, statistics may be recalculated frequently which can lead to variations in query execution plans. Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to undefined behavior. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
Consequently, different estimates could be produced when recalculating statistics leading to different choices in query execution plans and variation in query performance. Decreasing the value too much, however, could lead to the first problem of ...
https://dev.mysql.com/doc/refman/8.0/en/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. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
In order to minimize confusion with standard MySQL session variables, we refer to the variables that correspond to these NDB API session counters as “_session variables”, with a leading underscore. We refer to the related status variables as ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...