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/aggregate-functions.html
Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned BIGINT values, so they had a maximum range of 64 bits. The result is truncated to the maximum length that is given by the group_concat_max_len ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
To tell MySQL to accept the query, you can use the ANY_VALUE() function: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; Alternatively, disable ONLY_FULL_GROUP_BY. Here, too, ANY_VALUE() can be used, if it is immaterial which name ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
For example: [mysqld] innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend The autoextend and max attributes can be used only for the data file that is specified last. To specify a maximum size for an auto-extending data file, use the max ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
(This technique is inapplicable if NULL must be permitted as a valid name value.) Use ANY_VALUE() to refer to address: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; In this case, MySQL ignores the nondeterminism of address values ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
--max-allowed-packet=value Command-Line Format --max-allowed-packet=value Type Numeric Default Value 16777216 The maximum size of the buffer for client/server communication. --max-join-size=value Command-Line Format --max-join-size=value Type ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
This is equivalent to the expression (min <= expr AND expr <= max) if all the arguments are of the same type. expr NOT BETWEEN min AND max This is the same as NOT (expr BETWEEN min AND max). The number of values in the IN() list is only limited by ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The only aggregate functions used in the select list (if any) are MIN() and MAX(), and all of them refer to the same column. Any other parts of the index than those from the GROUP BY referenced in the query must be constants (that is, they must be ... The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Beginning with version 8.0.30, NDB supports two column comment options BLOB_INLINE_SIZE and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
To use the AUTO_INCREMENT mechanism with an InnoDB table, an AUTO_INCREMENT column must be defined as the first or only column of some index such that it is possible to perform the equivalent of an indexed SELECT MAX(ai_col) lookup on the table to ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
First approach to solving the problem: For each salesperson, calculate the maximum sale size, and also find the customer who provided this maximum. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...