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/union.html
Left-hand nesting of unions, previously permitted only in subqueries, is now permitted in top-level statements. For example, this statement is now accepted as valid: (SELECT 1 UNION SELECT 1) UNION SELECT 1; Locking clauses (FOR UPDATE, LOCK IN ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use of a particular index, or set the max_seeks_for_key system variable to ensure that MySQL ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. We try to keep the manual up to date by updating ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
Other reasons for problems with aborted connections or aborted clients: The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld. If connection problems occur such as communication errors ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
In MySQL 8.0.21 and later, it is also possible to create an index on a JSON column using the JSON_VALUE() function with an expression that can be used to optimize queries employing the expression. A secondary index defined on a virtual column is ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
(See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by ...