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/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS table or the SHOW COLLATION ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
Beginning with MySQL 8.0.28, utf8mb3 is also displayed in place of utf8 in columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general ...
https://dev.mysql.com/doc/refman/8.0/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. The ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. This differs from the ENUM data type ... Many server system variables are dynamic and can be set at ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-server-states.html
The Performance Schema table replication_group_members shows the state for each member in a group. If you see this status for other servers, it can also mean that the member where you query this table is part of a partition, where a subset of the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-consensus-leader.html
The Performance Schema table replication_group_communication_information shows the current preferred and actual consensus leader, with the preferred leader being Group Replication’s choice, and the actual leader being the one selected by the group ... By default, the group communication engine for Group Replication (XCom, a Paxos variant) operates using every member of the replication group as a ...