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/alter-database.html
For a MERGE table such as CREATE TABLE s1.t(i int) ENGINE MERGE UNION (s2.t, s3.t), INSERT_METHOD=..., the following behavior applies: Inserting into the MERGE table (INSERT into s1.t) fails if at least one of s1, s2, s3 is read only, regardless of ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). For MyISAM tables, if you use the QUICK modifier, the storage engine does not merge index leaves during delete, which may speed up some kinds of ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
RENAME does not work with TEMPORARY tables or tables used in a MERGE table. Creation of a table of type MERGE does not check whether the underlying tables are compatible types. If you use ALTER TABLE to add a UNIQUE index to a table used in a MERGE ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. In this case, partitions 4 and 5 are merged ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
MySQL includes a MERGE library that enables you to handle a collection of MyISAM tables that have identical structure as a single MERGE table. The effective maximum table size for MySQL databases is usually determined by operating system ...
https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
Because the STRAIGHT_JOIN modifier in the outer query prevents semijoin, the optimizer refuses the merge, causing derived table evaluation using a materialized table. If a subquery was converted to a semijoin, you should see that the subquery ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the file. If an insert failed due to a page being full, a pessimistic insert would be performed, which involves ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...