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/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-legacy-filtering.html
Legacy Mode Audit Log Filtering is deprecated as of MySQL 8.0.34. Note The audit_log_policy legacy-mode system variable is deprecated as of MySQL 8.0.34. Note This section describes legacy audit log filtering, which applies if the audit_log plugin ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
When IGNORE—or LOCAL without REPLACE—is specified, data interpretation errors become warnings and the load operation continues, even if the SQL mode is restrictive. Interpretation of field values and assignment to table columns depends on these ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
That is, a SELECT that does not use a FOR UPDATE or LOCK IN SHARED MODE clause. Until updates or explicit locks are required, a transaction stays in read-only mode. The transaction is started without the READ ONLY option, but no updates or ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... ON DUPLICATE KEY UPDATE Statement” for conditions under which the SELECT columns can be referred ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
GTIDs are stored in the mysql.gtid_executed table only when gtid_mode is ON or ON_PERMISSIVE. If binary logging is enabled (log_bin is ON), from MySQL 8.0.17 for the InnoDB storage engine only, the server updates the mysql.gtid_executed table in the ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. When this member action is disabled and not ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. MySQL account information is stored in the tables of the mysql system schema. This database and the ...