PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-table.html
The value can be UNIQUE, PRIMARY KEY, FOREIGN KEY, or (as of MySQL 8.0.16) 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 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/en/keyring-system-variables.html
These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, “Keyring Plugin Installation”). keyring_aws_cmk_id Command-Line Format --keyring-aws-cmk-id=value System Variable keyring_aws_cmk_id Scope ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
Whether or not you use distinct server binaries, each instance that you run must be configured with unique values for several operating parameters. However, if you need to run multiple servers on a more permanent basis, it is more convenient to use ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
Each server that supports named-pipe connections must use a unique pipe name. Enable such connections by starting the server with the shared_memory system variable enabled and specify a unique shared-memory name for each server by setting the ...