PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
See Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as number of ... The ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Account locking can be set or changed with the CREATE USER or ALTER USER statement. When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
To require use of encrypted connections by a MySQL account, use CREATE USER to create the account with a REQUIRE SSL clause, or use ALTER USER for an existing account to add a REQUIRE SSL clause. This section describes options supported by most ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. The ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-invalid-data.html
It is possible to alter this behavior to be more forgiving of invalid values, such that the server coerces them to valid ones for data entry, by disabling strict SQL mode (see Section 7.1.11, “Server SQL Modes”), but this is not recommended. By ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. CREATE ROLE [IF NOT ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] [password_option | lock_option] ... It enables authentication, role, ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
If you make a poor choice and it turns out later that you need a longer field, MySQL provides an ALTER TABLE statement. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with ...