Search Results
https://dev.mysql.com/doc/connector-j/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/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/connector-j/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/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...If that statement name exists when the procedure is called, its previous content is ...
https://dev.mysql.com/doc/internals/en/execute-load-query-event.html
Binlog::EXECUTE_LOAD_QUERY_EVENT: Post-header 4 slave_proxy_id 4 execution time 1 schema length 2 error-code 2 status-vars length Payload 4 file_id 4 start_pos 4 end_pos 1 dup_handling_flags See Binlog::QUERY_EVENT .
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. file_name Sometimes you may want your script to display progress information to the user. Previously, it read them and sent them to the server, resulting in a ... The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that ...