PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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 12.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/5.7/en/mysql-cluster-programs-ndb-move-data.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --connect-retries Command-Line Format ...Usage ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
Table 4.23 mysqlbinlog Options Option Name Description Introduced Deprecated --base64-output Print binary log entries using base-64 encoding --bind-address Use specified network interface to connect to MySQL Server --binlog-row-event-max-size Binary ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...