Search Results
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
For this reason, INSTALL PLUGIN requires the INSERT privilege for the mysql.plugin table. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation state of loaded plugins at startup, and ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
If you insert +0003.1 into a DECIMAL(5,1) column, it is stored as 3.1. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE (which is not recommended), the changes have no effect on privilege checking until you either tell the server to reload the tables or restart it. If the ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You can rename tables locked with a LOCK TABLES statement, ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Important Do not attempt to update or insert rows in the mysql.slave_master_info or mysql.slave_relay_log_info tables manually. A replica server creates two replication metadata repositories, the connection metadata repository and the applier ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. The BLACKHOLE storage engine accepts data but discards it and does not store it. Updates and deletes are handled differently ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-limit.html
Statement-based replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
This means that, when you are replicating large column values using row-based replication, you must take care to set max_allowed_packet large enough to accommodate the largest row in any table to be replicated, even if you are replicating updates ...