PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table has these columns: TRX_ID A unique transaction ID number, internal to InnoDB. TRX_UNIQUE_CHECKS Whether unique checks are turned on or off for the current transaction. The INNODB_TRX table provides information about every ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-table-constraints-table.html
The value can be UNIQUE, PRIMARY KEY, FOREIGN KEY or CHECK. The UNIQUE and PRIMARY KEY information is about the same as what you get from the Key_name column in the output from SHOW INDEX when the Non_unique column is 0. The TABLE_CONSTRAINTS table ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locking-reads.html
For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. In MySQL, the specific task of generating a unique identifier actually can be accomplished using ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-requirements.html
This includes NULL, primary key, unique Key, check, and foreign key constraints. Such constraints include NULL, primary key, unique key, check, and foreign key constraints. Review the following requirements and restrictions for table annotations ...
https://dev.mysql.com/doc/refman/9.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...
https://dev.mysql.com/doc/refman/9.7/en/ldap-pluggable-authentication.html
These LDAP entries are available in the directory managed by the LDAP server, to provide distinguished name values that uniquely identify each user: uid=betsy_ldap,ou=People,dc=example,dc=com uid=boris_ldap,ou=People,dc=example,dc=com CREATE USER ...
https://dev.mysql.com/doc/refman/9.7/en/limit-optimization.html
If you combine LIMIT row_count with DISTINCT, MySQL stops as soon as it finds row_count unique rows. If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and ...
https://dev.mysql.com/doc/refman/9.7/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...