Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function. Common table expression with window function: WITH s1 AS ( SELECT article, dealer, ... Task: For each article, find the dealer or dealers with the most expensive ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 firewall ...
https://dev.mysql.com/doc/refman/8.4/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. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/group-replication-change-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. This section explains how to change which member of a single-primary group is the primary, using the ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not try. Note that in the case of an ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-socket-layer-support-ssl.html
This variable has the following possible values: Table 20.1 group_replication_ssl_mode configuration values Value Description DISABLED Establish an unencrypted connection (the default). REQUIRED Establish a secure connection if the server supports ... Secure sockets can be used for group communication connections between members of a ...
https://dev.mysql.com/doc/refman/8.4/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...