PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
If you really want rows sorted by the MySQL rule and secondarily by code point value, it is easy: ORDER BY s1 COLLATE utf32_unicode_ci, s1 COLLATE utf32_bin For supplementary characters based on UCA versions higher than 4.0.0 (for example, ... This ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Each row is compressed separately, so there is very little access overhead. The header for a row takes up one to three bytes depending on the biggest row in ...Compressed tables have the following characteristics: Compressed tables take very little disk ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
Suppose that table t1 contains a row where column1 = 5 and column2 = 6; meanwhile, table t2 contains a row where column1 = 5 and column2 = 7. This reflects the cardinality check that the optimizer performs as part of evaluating the JOIN or WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
row *************************** Level: Note Code: 1588 Message: Event execution time is in the past and ON COMPLETION NOT PRESERVE is set. For example, you could use the GET_LOCK() function, or row or table locking. CREATE [DEFINER = user] EVENT ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs (Result consisted of more than one row). For ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
In the following array, this is the element in the fourth row down, third value from the end. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
When a read/write transaction is ready to commit at the originating server, the server atomically broadcasts the write values (the rows that were changed) and the corresponding write set (the unique identifiers of the rows that were updated). During ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
mysql> SELECT JSON_MERGE('[1, 2]', '[true, false]'); +---------------------------------------+ | JSON_MERGE('[1, 2]', '[true, false]') | +---------------------------------------+ | [1, 2, true, false] | +---------------------------------------+ 1 ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
A multiple-column index can be considered a sorted array, the rows of which contain values that are created by concatenating the values of the indexed columns. If separate single-column indexes exist on col1 and col2, the optimizer attempts to use ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-logbuffers.html
One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer used during backup to copy fragments to backup files. The other row has the log type BACKUP-LOG, which displays the amount of log buffer used during the backup to ... The logbuffer table provides information on NDB Cluster log buffer ...