Search Results
https://dev.mysql.com/doc/refman/9.7/en/alter-library.html
Following execution of this statement, the updated comment can be viewed in the output of SHOW CREATE LIBRARY and in the ROUTINE_COMMENT column of the Information Schema LIBRARIES table. ALTER LIBRARY library_name COMMENT "comment_text" This ...
https://dev.mysql.com/doc/refman/9.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option[, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-update.html
If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. The ...
https://dev.mysql.com/doc/refman/9.7/en/arithmetic-functions.html
Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/9.7/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-elements.html
MySQL Enterprise Audit is based on the audit log component and related elements: A server-side component named audit_log examines auditable events and determines whether to write them to the audit log. Tables in the mysql system database provide ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-elements.html
MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable events and determines whether to write them to the audit log. Tables in the mysql system database provide ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-formats.html
In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are affected. The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/binlog-replication-configuration-overview.html
If required, you can configure the replica to process only events that apply to particular databases or tables. This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance ...
https://dev.mysql.com/doc/refman/9.7/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...