Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows. For ...If the subquery returns more than one row, error 1242 ...Consider the following example: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); If SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...Character (nonbinary) string values are converted from their character set to ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-dataerror.html
This exception is raised when there were problems with the data. Examples are a column set to NULL that cannot be NULL, out-of-range values for a column, division by zero, column count does not match value count, and so on.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-dataerror.html
This exception is raised when there were problems with the data. Examples are a column set to NULL that cannot be NULL, out-of-range values for a column, division by zero, column count does not match value count, and so on.
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-warning.html
It is included to be compliant with the Python Database Specification v2.0 (PEP-249). Consider using either more strict Server SQL Modes or the raise_on_warnings connection argument to make Connector/Python raise errors when your queries produce ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-warning.html
It is included to be compliant with the Python Database Specification v2.0 (PEP-249). Consider using either more strict Server SQL Modes or the raise_on_warnings connection argument to make Connector/Python raise errors when your queries produce ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/error-reference-introduction.html
The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action. The MySQL client library takes errors received from the server and makes them available to the ...