PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
Component order is significant because the server executes components in the order listed. This configuration order is required regardless of whether variable assignment is performed on the command-line, in an option file, or using SET PERSIST. In ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-column-group-row.html
Common table expression with window function: WITH s1 AS ( SELECT article, dealer, price, RANK() OVER (PARTITION BY article ORDER BY price DESC ) AS `Rank` FROM shop ) SELECT article, dealer, price FROM s1 WHERE `Rank` = 1 ORDER BY article; . Task: ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Each ordered index requires 10 bytes storage per record, using DataMemory. Creating a primary key or unique index also creates an ordered index, unless this index is created with USING HASH. This is due to the fact that less memory is required ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Table 13.2 WKB Components Example Component Size Value Byte order 1 byte 01 WKB type 4 bytes 01000000 X coordinate 8 bytes 000000000000F03F Y coordinate 8 bytes 000000000000F0BF Component representation is as follows: The byte order indicator is ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
Suppose that an index my_idx includes three columns named col_a, col_b, and col_c, in that order. READ syntax fetches a row from the table in index order that matches the WHERE condition. READ syntax fetches a row from the table in natural row order ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The secondary index entries are pre-sorted, and so can be loaded in order. Reordering columns To reorder columns, use FIRST or AFTER in CHANGE or MODIFY operations. Modifying STORED column order ALTER TABLE t1 MODIFY COLUMN c2 INT GENERATED ALWAYS ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
Evaluation of statements that contain an ORDER BY clause and a different GROUP BY clause, or for which the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue. Evaluation of DISTINCT combined with ORDER BY ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
OpenLDAP uses configuration options in this order of precedence: Configuration specified by the LDAP client. This part of the authentication string lists group names in the order grp1, grp2, grp3. The LDAP plugin compares that list with the set of ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
Use of a column with RAND() values in an ORDER BY or GROUP BY clause may yield unexpected results because for either clause a RAND() expression can be evaluated multiple times for the same row, each time returning a different result. ABS(X) Returns ...