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/numeric-type-syntax.html
When using operators (+, -, *, and so on) where both operands are integers. The -, +, and * operators use BIGINT arithmetic when both operands are integer values. For integer data types, M indicates the minimum display width. Display width is ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. A communication packet is a single SQL statement sent to the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. In addition, both RANGE COLUMNS partitioning and ... The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
For example, both VALUES IN (NULL) and VALUES IN (1, 4, 7, NULL) are valid, as are VALUES IN (1, NULL, 4, 7), VALUES IN (NULL, 1, 4, 7), and so on. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
SQL Statement Corresponding Server Command PREPARE SQLCOM_PREPARE EXECUTE SQLCOM_EXECUTE DEALLOCATE PREPARE, DROP PREPARE SQLCOM_DEALLOCATE PREPARE Performance Schema prepared statement instrumentation covers both protocols. The Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support-problems.html
Another cause of this problem may be that Perl and MySQL are not both compiled with gcc. In this case, you can solve the mismatch by compiling both with gcc. If Perl reports that it cannot find the ../mysql/mysql.so module, the problem is probably ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
Plugins normally are installed using either a plugin-loading option at startup or with INSTALL PLUGIN at runtime, but not both. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
Exact-value numeric literals have an integer part or fractional part, or both. The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals.