Search Results
https://dev.mysql.com/doc/refman/8.4/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: The error ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
You should try to create a reproducible test case that demonstrates the problem. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
The same restrictions apply to internal temporary tables created to hold the result set for a cursor as for other uses of internal temporary tables. Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A ...
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
.isl files: InnoDB Symbolic Link files containing the location of file-per-table tablespace files created outside of the data directory. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-limitations.html
Manual creation of database directories under the data directory (for example, with mkdir) is unsupported. Manually created database directories are not recognized by the MySQL Server. This section describes temporary limitations introduced with ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the ...
https://dev.mysql.com/doc/refman/8.4/en/deallocate-prepare.html
If too many prepared statements are created and not deallocated by either the DEALLOCATE PREPARE statement or the end of the session, you might encounter the upper limit enforced by the max_prepared_stmt_count system variable. {DEALLOCATE | DROP} ...