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/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
The rounded values are also used by the NDB kernel for calculating Information Schema FILES column values and other purposes. For an NDB table assigned to a tablespace, only those columns which are not indexed are stored on disk, and actually use ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The number, order, names, and types of columns and indexes of the partitioned table and the nonpartitioned table must match exactly. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
In this case, the difference in the second column name is lost and both statements are considered the same. The statement event tables (events_statements_current, events_statements_history, and events_statements_history_long) have columns for ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
If this is not the case, an error is generated and the function does not run, unless log_bin_trust_function_creators=1 is specified to override this check (see below). SELECT statements when the source column expressions refer to local variables.
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
If InnoDB generates a clustered index automatically, the index contains row ID values. Records in a clustered index are updated in-place, and their hidden system columns point undo log entries from which earlier versions of records can be ...It ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, sh_req, sh_req_imm_ok, sh_wait_ok, and sh_wait_fail represent cumulative numbers of requests since the table or fragment was created, or since the last restart ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...