Search Results
https://dev.mysql.com/doc/refman/9.7/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for ...
https://dev.mysql.com/doc/refman/9.7/en/components.html
MySQL distributions include several components that implement server extensions: Components for configuring error logging. See Section 7.4.2, “The Error Log”, and Section 7.5.3, “Error Log Components”. For example, the log_filter_dragnet ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
Make sure that any error handlers in your application also ROLLBACK incomplete changes or COMMIT completed changes. Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-check-constraints.html
CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. If an error occurs, handling of changes already applied differs for transactional and ... CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-select.html
The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax error. If neither IGNORE nor REPLACE is specified, duplicate unique key values result in an error. Such statements ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
EXTENT_SIZE: This option is specific to NDB, and is not supported by InnoDB, where it fails with an error. INITIAL_SIZE: This option is specific to NDB, and is not supported by InnoDB, where it fails with an error. CREATE TABLESPACE ts1 ...The ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/9.7/en/drop-spatial-reference-system.html
Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the SRID value exists, an error occurs unless IF EXISTS is specified. If the SRID value is used by some column in an existing table, an error occurs. For example: mysql> DROP ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
The index value of the empty string error value is 0. If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. Duplicate values in the definition cause a warning, or an error if strict SQL mode is enabled. An ENUM ...
https://dev.mysql.com/doc/refman/9.7/en/events-configuration.html
This causes the Event Scheduler to stop the next time it tries to execute a scheduled event, after writing a message to the server error log. No warnings or errors are generated in such cases (provided that the statements are themselves valid).