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/create-table-foreign-keys.html
Enabling foreign_key_checks does not trigger a scan of table data, which means that rows added to a table while foreign_key_checks is disabled are not checked for consistency when foreign_key_checks is re-enabled. MySQL supports foreign keys, which ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
The VIRTUAL or STORED keyword indicates how column values are stored, which has implications for column use: VIRTUAL: Column values are not stored, but are evaluated when rows are read, immediately after any BEFORE triggers. Triggers cannot use ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based metadata storage included expensive file scans, susceptibility to file system-related bugs, complex code for handling of replication and ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
A multiple-table insert can be accomplished using a trigger whose FOR EACH ROW clause contains multiple INSERT statements within a BEGIN ... Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
Note It is not possible to issue FLUSH statements within stored functions or triggers. However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. | tables_option } flush_option: { BINARY LOGS ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member actions. They can only be used by administrators with the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-membership.html
If existing members agree that a new server should become part of the group, the group is reconfigured to integrate that server in it, which triggers a view change. If a server leaves the group, either voluntarily or not, the group dynamically ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
The events that relate to the consistency of a system can be split into control operations, either manual or automatically triggered by failures; and data flow operations. in single-primary groups, primary failover, which can also be an operation ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
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 executing the statement. Most of these statements also cause an implicit commit after ...