Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 8.4. A multi-source replication topology requires at least ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
For example: mysql> STOP GROUP_REPLICATION; mysql> CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'gr_repl'@'%.example.com' FOR CHANNEL 'group_replication_recovery'; mysql> FLUSH PRIVILEGES; mysql> START GROUP_REPLICATION; For Group ... You ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. In the event of an unexpected server exit or deliberate restart after issuing RESET REPLICA but before issuing START REPLICA, replication ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
The position before a locking clause is deprecated; expect support for it to be removed in a future version of MySQL. Alternatively, if the MySQL client software is installed on the remote host, you can use a client command such as mysql -e "SELECT ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
For information about MySQL storage engines, see Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. row *************************** Engine: ARCHIVE Support: YES Comment: Archive storage engine Transactions: NO XA: NO ... SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
A global status variable may represent status for some aspect of the server itself (for example, Aborted_connects), or the aggregated status over all connections to MySQL (for example, Bytes_received and Bytes_sent). mysql> SHOW STATUS; ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. MySQL maps certain data types used by other SQL database vendors to MySQL types. These might be changes to a data type, to ...