Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Note In MySQL 8.3 and earlier, DROP VIEW returns an error if any views ...Due to the change in behavior in MySQL 8.4, a partially completed DROP VIEW operation on a MySQL 8.3 replication source server fails when replicated on a MySQL 8.4 ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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).
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. A warning occurs rather than an error because MySQL is not set to use strict SQL mode. With strict ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...