Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Thus, even though ssn is defined as VARCHAR(11), if the ssn column has a multibyte character set, it may appear to be longer than 11 bytes when passed to a loadable function, and returns NULL while logging the error. Before using MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Thus, even though ssn is defined as VARCHAR(11), if the ssn column has a multibyte character set, it may appear to be longer than 11 bytes when passed to a loadable function, and an error occurs. Before using MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
In MySQL 8.4, STR_TO_DATE() performs complete range checking and raises an error if the date after conversion would be invalid. This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
For temporal types that include a date part (DATE, DATETIME, and TIMESTAMP), use of these values may produce warning or errors. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
If the plugin fails to initialize, check the server error log for diagnostic messages. This section describes how to install or uninstall the ddl_rewriter plugin. For general information about installing plugins, see Section 7.6.1, “Installing ...
https://dev.mysql.com/doc/refman/8.4/en/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in an error. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.