PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-ce-sets.html
MySQL provides some support for character sets used in the Czech Republic, Slovakia, Hungary, Romania, Slovenia, Croatia, Poland, and Serbia (Latin).
https://dev.mysql.com/doc/refman/8.0/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated in MySQL 8.0.28.
https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling-restrictions.html
SIGNAL, RESIGNAL, and GET DIAGNOSTICS are not permissible as prepared statements. In standard SQL, the first condition relates to the SQLSTATE value returned for the previous SQL statement. For example, this statement is invalid: PREPARE stmt1 FROM ...
https://dev.mysql.com/doc/refman/8.0/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/8.0/en/constraint-invalid-data.html
By default, MySQL 8.0 rejects invalid or improper data values and aborts the statement in which they occur. It is possible to alter this behavior to be more forgiving of invalid values, such that the server coerces them to valid ones for data ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-limitations.html
DDL operations take longer due to writing to storage, undo logs, and redo logs instead of .frm files. This section describes temporary limitations introduced with the MySQL data dictionary. Manual creation of database directories under the data ...
https://dev.mysql.com/doc/refman/8.0/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} ...