PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math.html
For example, you can treat a value that is too large for a column as an error rather than having the value truncated to lie within the range of the column's data type. Precision math is based on these two features: SQL modes that control how strict ...For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
Requirements for Proxy User Support For proxying to occur for a given authentication plugin, these conditions must be satisfied: Proxying must be supported, either by the plugin itself, or by the MySQL server on behalf of the plugin. The account for ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
These columns can contain other than integer values, since the hashing function supplied by MySQL guarantees an integer result regardless of the column data type. For HASH partitioning, the user-supplied expression must evaluate to an integer value.
https://dev.mysql.com/doc/refman/8.0/en/values.html
Each ROW() in the same VALUES statement must have the same number of values in its value list. The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. The constructed ...In other words, it is a table value constructor which also functions as a standalone SQL ... VALUES is ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. For functions that take multiple geometry arguments, if those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS error occurs. If ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. This is done ...In the latter case, you should run REPAIR TABLE on the ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The data also shows the number of retries for the last transaction and the transaction currently in progress, and enables you to identify the transient errors that caused the transactions to be retried. Transactions are automatically retried when ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
For Group Replication connections between server instances that are on different machines, you must provide public IP addresses and specify these as an explicit allowlist. If you specify any entries for the allowlist, the private and localhost ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-configuration-table.html
GTID_ONLY Indicates if this channel only uses GTIDs for the transaction queueing and application process and for recovery, and does not persist binary log and relay log file names and file positions in the replication metadata repositories. (CHANGE ... This table shows the configuration parameters used by the replica for connecting to the ...For ...