Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/select-into.html
If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs (Result consisted of more than one row). INTO statements that occur as ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/srjsapi-warning.html
Warning represents a warning raised by statement execution, and has the following properties: code: MySQL error code (integer). Can be any one of 1 (NOTE), 2 (WARNING), or 3 (ERROR). You can also employ the JavaScript Error object, such as obtained ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 9.6 server on the same data directory, and fix the cause of any errors. Warning Applying SQL extracted from a previous MySQL release to a new MySQL release may result in errors due ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/mysql-enterprise-backup/9.7/en/meb-backup-osb.html
sbt_error_msg: Error message, when an error occurs while retrieving information for the tape backup. sbt_error_code: Error code, when an error occurs while retrieving information for the tape backup. Tape drives are affordable, high-capacity ...