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/locking-service.html
Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 characters. A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error.
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
AND key_partN cmp constN; Here, const1, const2, … are constants, cmp is one of the =, <=>, or IS NULL comparison operators, and the conditions cover all index parts. For a BTREE index, an interval might be usable for conditions combined with AND, ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
Collation The collation for nonbinary string columns, or NULL for other columns. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can tell whether the column permits NULL ... SHOW [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table. SELECT left_tbl.* FROM { OJ left_tbl LEFT OUTER JOIN right_tbl ON left_tbl.id = right_tbl.id } ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
Attempting to set the value of either of these two variables to an integer greater than 65,535 or less than 0 causes its value to be set to 65,535 instead. Attempting to set the value of auto_increment_increment or auto_increment_offset to a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. This condition does not apply if the WITHOUT VALIDATION ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.21.3, “Expression Handling”, and Section 12.21.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. As of MySQL 5.7.19, MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
This is NULL if the column has an explicit default of NULL, or if the column definition includes no DEFAULT clause. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can ...