PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
Only statements that modify databases or tables count against the update limit. An “account” in this context corresponds to a row in the mysql.user system table. That is, a connection is assessed against the User and Host values in the user ...
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. MySQL ...The available referential actions are RESTRICT, CASCADE, SET NULL, and NO ACTION (the ...
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. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables.
https://dev.mysql.com/doc/refman/8.0/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
The same restriction applies to any operation that modifies data dictionary tables, such as ANALYZE TABLE and ALTER TABLE tbl_name ENGINE=engine_name. You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 11.2, ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
Table 8.11 Example authentication_policy Values authentication_policy Value Effective Policy '*' Permit only creating or altering accounts with one factor. Authentication involves one party establishing its identity to the satisfaction of a second ...Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
New connections established after execution of ALTER INSTANCE RELOAD TLS use the new TLS context. These system variables on the server side specify the certificate and key files the server uses when permitting clients to establish encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. The ALTER TABLE statement produces three warning messages (strict SQL mode is disabled for the example to ...mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of the mysql system database. The MySQL server reads the contents of these ...