Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
For a row deletion logged in row format (which are logged as a Delete_rows_log_event), the DELETE privilege on the relevant table. The Format_description_log_event, which deletes any temporary files created by LOAD DATA events, is processed without ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
If the current transaction has a savepoint with the same name, the old savepoint is deleted and a new one is set. In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. All ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
In a DELETE trigger, only OLD.col_name can be used; there is no new row. To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
The following example establishes the server token list, modifies it by adding a new token, deletes some tokens, and displays the resulting token list: mysql> SELECT version_tokens_set('tok1=a;tok2=b'); +-------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. Then use SC DELETE ... On Windows, ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log file. While removing an expression, after decrementing the reference count, even the underlying ...It ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #37635908) Replication: In a source-replica setup, the replica encountered irregular failures of UPDATE and DELETE statements with ER_KEY_NOT_FOUND errors on the same table. (The replica's binary log and GTID records showed that the row ...(Bug ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
It returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
These statements require the INSERT and DELETE privilege, respectively, for the mysql database. To use CREATE FUNCTION or DROP FUNCTION, you must have the INSERT or DELETE privilege, respectively, for the mysql database. This is necessary because ...