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/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. Control over handling of ... MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
An error occurs for old accounts that do not exist or new accounts that already exist. As of MySQL 8.0.22, RENAME USER fails with an error if any account to be renamed is named as the DEFINER attribute for any stored object. (That is, the statement ... RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. such statements produce a warning in the error ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-skip.html
First you need to identify the replicated event that caused the error. Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. You can use mysqlbinlog to ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
If any of the transactions that should be sent by the source have been purged from the source's binary log, or added to the set of GTIDs in the gtid_purged system variable by another method, the source sends the error ... GTIDs replace the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-restrictions.html
The parser recognizes these window constructs which nevertheless are not supported: The GROUPS frame units specifier is parsed, but produces an error. The EXCLUDE clause for frame specification is parsed, but produces an error. The SQL standard ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and writes a message to the error log: Access denied for user ... MySQL ...