Search Results
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
I'm attempting to execute a DELETE query but the query fails with an "Error Code: 1175" error. My MySQL server connection is timing out with an error like "Error Code: 2013. I'm attempting to execute a DELETE query but the query fails with an "Error ...The statements added at the start of the code are: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; These statements function as follows: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;: Determines whether InnoDB performs duplicate key ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
NdbInterpretedCode::getNdbError() Description This method returns the most recent error associated with this NdbInterpretedCode object. Signature int interpret_exit_nok ( Uint32 ErrorCode = 626 // HA_ERR_KEY_NOT_FOUND ) Parameters This method takes ... This section provides information about the NdbInterpretedCode class, which can be used to prepare and execute an NDB API interpreted ...
https://dev.mysql.com/doc/refman/8.4/en/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ...The condition raised by the statement goes unhandled and terminates the procedure with an error: mysql> CALL p4(); ERROR 1051 (42S02): Unknown table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
The following code snippets illustrate this: string sql = "SELECT * FROM TestTable"; ... The following code shows how the event handlers are set up. script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
The following code snippets illustrate this: string sql = "SELECT * FROM TestTable"; ... The following code shows how the event handlers are set up. script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
Questions 3.14.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 What is going on? I can connect just fine ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
can_handle_exp_pwd Can Handle Expired Password 0 Indicates that the application can deal with an expired password, which is signalled by an SQL state of 08004 (“Server rejected the connection”) and a native error code ...This option is ...On ...