PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. 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 ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
In MySQL version 5.7.5, this variable was added as simplified_binlog_gtid_recovery and in MySQL version 5.7.6 it was renamed to binlog_gtid_simple_recovery. This is the same as the value of the Executed_Gtid_Set column in the output of SHOW MASTER ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column. It does not apply to TIMESTAMP columns, which always require a valid date. Normally, you generate the next sequence number ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
For example, a table rename failure could result in a “missing” *.ibd file without an MLOG_FILE_DELETE record. In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
(It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format --keyring-encrypted-file-password=password Introduced 5.7.21 System Variable ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 6.4.4.1, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
Strictly speaking, this account name is not reserved, in the sense that some installations rename the root account to something else to avoid exposing a highly privileged account with a well-known name. Use of the mysql.sys account avoids problems ... One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
To upgrade in this case, remove or rename the existing sys schema first. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or removes the root account. MySQL 5.7 includes the sys schema, a set of objects that helps ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column values. Corresponding columns in the foreign key and the referenced key must have similar ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...