PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... ANALYSE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Moreover, InnoDB provides some additional functionality that enables better management and handling of ...Transactions are executed optimistically and then, at commit time, are checked for ...This enables Group Replication to ...
https://dev.mysql.com/doc/refman/8.0/en/preface.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.44. Warranty Disclaimer The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, ...Differences between minor versions of MySQL 8.0 are noted in the present text with reference to release numbers ...License Restrictions This software and related documentation are provided ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
For more information, see Section 13.5, “The JSON Data Type”, and Section 14.17, “JSON Functions”. Option Value Meaning 1 Reject the document and produce an error. The srid argument, if given, must be a 32-bit unsigned integer. For ... This ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Rows updated to values that would cause data conversion errors are updated to the closest valid values instead. If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the ...With the IGNORE modifier, the update statement does not abort even if errors occur during the ...An UPDATE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
If the first argument is 'point_square' or 'end_flat', the points_per_circle argument must not be given or an ER_WRONG_ARGUMENTS error occurs. If the fractional distance argument is outside the range [0.0, 1.0], an ER_DATA_OUT_OF_RANGE error occurs.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
In the token list for a given server, token names represent database names and token values are read or write depending on whether the database must be used in read-only fashion or whether it can take reads and writes. But suppose that the ...Client ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
The CREATE TABLE statement in InnoDB is processed as a single transaction. SELECT.) Statements that implicitly use or modify tables in the mysql database. LOAD DATA causes an implicit commit only for tables using the NDB storage engine. The ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error. If the timeout is reached without successful lock acquisition, an ER_LOCKING_SERVICE_TIMEOUT error ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...