Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. Important Only a single ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
Your database has now been restored to the point-in-time of interest, tp, right before the table pets.cats was dropped. The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
To revoke all privileges from a user, use one of the following statements; either of these statements drops all global, database, table, column, and routine privileges for the named users or roles: REVOKE ALL PRIVILEGES, GRANT OPTION FROM ...[IGNORE ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/internals/en/select-union.html
Create a temporary table for storing union results (if UNION without ALL option, 'distinct' parameter will be passed to the table creation procedure). A special fake_select_lex (SELECT_LEX) which is created for every UNION will be passed for this ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-21.html
(Bug #31237338, Bug #99371) An error was generated when the database name within a connection string that was passed to MySQL 5.6 or MySQL 5.7 did not match the casing used to search a related stored procedure. (Bug #30791289, Bug #98322) An ...Now, ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
The MySQL HeatWave Advisor is implemented as a stored procedure named heatwave_advisor, which resides in the MySQL sys schema. Running Advisor involves issuing a CALL statement for the stored procedure with optional arguments. The MySQL HeatWave ...