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/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.0/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
The maximum value is 100, which means no filtering of rows occurred. No matching min/max row (JSON property: message) No row satisfies the condition for a query such as SELECT MIN(...) FROM ... If you restrict queries with the max_join_size system ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Support for group functions (COUNT(), AVG(), STD(), SUM(), MAX(), MIN(), and GROUP_CONCAT()). The maximum index width for InnoDB tables is either 767 bytes or 3072 bytes. This section describes some of the important characteristics of the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
The optimizer can use extended secondary indexes for ref, range, and index_merge index access, for Loose Index Scan access, for join and sorting optimization, and for MIN()/MAX() optimization. To check whether disabling use of index extensions can ... InnoDB automatically extends each secondary index by appending the primary key columns to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 191 characters on a TEXT or VARCHAR column, assuming a utf8mb4 character set and the maximum of 4 bytes for each character. If you reduce the InnoDB page size to 8KB or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and MAX() on memcached data. The combination of InnoDB tables and memcached offers advantages ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. In previous MySQL versions, the system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
A maximum of two tablespaces is allocated to a session, one for user-created temporary tables and the other for internal temporary tables created by the optimizer. row *************************** FILE_NAME: ./ibtmp1 TABLESPACE_NAME: innodb_temporary ... InnoDB uses session temporary tablespaces and a global temporary ...