Search Results
https://dev.mysql.com/doc/refman/9.7/en/alter-instance.html
ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER ...The ...
https://dev.mysql.com/doc/refman/9.7/en/arithmetic-functions.html
* Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT 18014398509481984*18014398509481984.0; -> 324518553658426726783156020576256.0 mysql> SELECT 18014398509481984*18014398509481984; -> out-of-range error The last expression produces an error ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-reading.html
An audit_log_read() call to read events that does not specify a position produces an error under any of these conditions: A read sequence has not yet been initialized by passing a position to audit_log_read(). If an audit_log_read() argument ... The ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log component must be enabled or an error occurs. In addition, the audit tables must exist or an ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-reading.html
An audit_log_read() call to read events that does not specify a position produces an error under any of these conditions: A read sequence has not yet been initialized by passing a position to audit_log_read(). If an audit_log_read() argument ...
https://dev.mysql.com/doc/refman/9.7/en/binary-varbinary.html
For cases of truncation, to cause an error to occur (rather than a warning) and suppress insertion of the value, use strict SQL mode. For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that ...
https://dev.mysql.com/doc/refman/9.7/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/9.7/en/connecting-disconnecting.html
For help with other problems often encountered when trying to log in, see Section B.3.2, “Common Errors When Using MySQL Programs”. To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, ...
https://dev.mysql.com/doc/refman/9.7/en/cost-model.html
If the server does not recognize the cost name when it reads this table, it writes a warning to the error log. If the server finds that the cost value is invalid (nonpositive) when it reads this table, it writes a warning to the error log. If the ...
https://dev.mysql.com/doc/refman/9.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...