Search Results
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-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-union.html
Allocate JOIN structures and execute JOIN::prepare() for every SELECT to get full information about types of elements of SELECT list (results). We will need this object to store in every JOIN structure link on it, but we have not (yet) temporary ...
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/internals/en/com-stmt-execute.html
COM_STMT_EXECUTE asks the server to execute a prepared statement as identified by stmt-id. It sends the values for the placeholders of the prepared statement (if it contained any) in Binary Protocol Value form. The type of each parameter is made up ...
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/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/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/internals/en/selectexplain.html
For an EXPLAIN statement, for every SELECT, mysql_select will be called with option SELECT_DESCRIBE. For every SELECT in a given union, mysql_explain_union will call mysql_explain_select. mysql_select creates a JOIN for select if it does not ...