Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
The binary (prepared statement) protocol enables you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP), using the MYSQL_TIME structure. The members of this structure are described in Section 6.2, “C API Prepared ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Prepared statements transmit data between the client and server using C language variables on the client side that correspond to SQL values on the server side. To get the type codes, call mysql_stmt_result_metadata() after executing the statement ...If there is a mismatch between the C variable type on the client side and the corresponding SQL value type on the server side, MySQL performs implicit type conversions in both ...
https://dev.mysql.com/doc/refman/8.4/en/statement-labels.html
[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...If end_label is present, it must be the same as ...
https://dev.mysql.com/doc/refman/8.4/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
When the read_only system variable is enabled, account-management statements require the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege), in addition to any other required privileges. For more information, see Section 15.1.1, ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-statements.html
Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement. MySQL supports the IF, CASE, ...
https://dev.mysql.com/doc/refman/8.4/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. A compound statement is a block that can contain other blocks; declarations for variables, condition ...These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 27, Stored ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-commmitting-statements.html
(R-log-commit-statement) All other statements that have a pre-commit are written directly to the binlog. (Note: this is semantically equivalent to writing it to the SC and flushing the SC. However, due to requirements by NDB (which have not been ...
https://dev.mysql.com/doc/internals/en/multi-statement.html
A multi-statement is permitting COM_QUERY to send more than one query to the server, separated by ';' characters. The client must announce that it wants multi-statements by either setting the CLIENT_MULTI_STATEMENTS capability or by using ...
https://dev.mysql.com/doc/internals/en/prepared-statements.html
The prepared statement protocol was introduced in MySQL 4.1 and adds a few new commands: COM_STMT_PREPARE COM_STMT_EXECUTE COM_STMT_CLOSE COM_STMT_RESET COM_STMT_SEND_LONG_DATA It also defines a more compact resultset format that is used instead of ...