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/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-elements.html
The MYSQL_FIREWALL plugin, along with server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement Performance Schema and INFORMATION_SCHEMA tables that provide views into the registered profiles. Tables in the mysql system ... MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on the registered firewall profiles, renders a decision whether to execute or reject each ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
For example, a WKB value that corresponds to POINT(1 -1) consists of this sequence of 21 bytes, each represented by two hexadecimal digits: 0101000000000000000000F03F000000000000F0BF The sequence consists of the components shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
If a specific query kills mysqld and the tables involved were checked with CHECK TABLE before you ran the query, can you provide a reproducible test case? See Section 7.9, “Debugging MySQL”. This section also covers the related Lost connection ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema table replication_group_members, or the group_replication_primary_member status variable. This section explains how to change which member of a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-observability.html
The entire state of the system (including the view, conflict statistics and service states) can be queried through Performance Schema tables. For example, you can connect to a single server in the group and obtain both local and global information ... There is a lot of automation built into the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...