Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE EVENT. (See Section 15.1.13, “CREATE EVENT Statement”.) Any user can alter an event defined on ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.4/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...
https://dev.mysql.com/doc/refman/8.4/en/audit-api-message-emit.html
Because installing and uninstalling the audit_api_message_emit component installs and uninstalls the audit_api_message_emit_udf() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. The ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
A disadvantage of PERFORMANCE strategy is that it drops events when the buffer is full. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains UUID(). When one or more tables with AUTO_INCREMENT columns are updated and a ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for ...
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
For example: mysql> charset koi8r Charset changed The charset command issues a SET NAMES statement, and also changes the default character set that mysql uses when it reconnects after the connection has dropped. A “connection” is what a client ...