Search Results
https://dev.mysql.com/doc/internals/en/prepared-stored.html
Execution of such statements is performed in a batch mode, one query processed by the server at a time. Finally, the query is passed to the execution runtime — an interpreter that operates with and modifies both the parsed tree and the execution ... Let us start with a general description of the MySQL statement processing workflow in order to provide the reader with understanding of the problem of reexecution and vocabulary for the following ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-node-recovery-error.html
The following list enumerates all NDB errors of type NR (Node Recovery error).
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...This capability is enabled by special options that are specified either when you connect to the server with mysql_real_connect() or after connecting by calling ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements-callable.html
Although CallableStatement supports calling any of the Statement execute methods (executeUpdate(), executeQuery() or execute()), the most flexible method to call is execute(), as you do not need to know ahead of time if the stored procedure returns ...// // // Registers the second parameter as output, and // uses the type 'INTEGER' for values returned from // getObject() // cStmt.registerOutParameter(2, Types.INTEGER); // // Registers the named parameter 'inOutParam', and // uses the type 'INTEGER' for values returned from // getObject() // cStmt.registerOutParameter("inOutParam", Types.INTEGER); ...
https://dev.mysql.com/doc/internals/en/select-derived.html
Routine of execution derived tables and substituting temporary table instead of it (mysql_handle_derived()) will be called just after opening and locking all real tables used in query (including tables used in derived table query). If it is not ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements.html
If you do not know ahead of time whether the SQL statement will be a SELECT or an UPDATE/INSERT, then you can use the execute(String SQL) method. Statement objects allow you to execute basic SQL queries and retrieve the results through the ...To ...
https://dev.mysql.com/doc/connectors/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...There are two types of single statements: Simple: these do not include a BEGIN-END body ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...There are two types of single statements: Simple: these do not include a BEGIN-END body ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
If you execute a statement multiple times, mysql_stmt_execute() closes any open cursor before opening a new one. int mysql_stmt_execute(MYSQL_STMT *stmt) Description mysql_stmt_execute() executes the prepared query associated with the statement ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
If the named connection is executing a statement that is not explainable, an error occurs. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION ...Because of ...