Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
All DDL (Data Definition Language) statements are executed using a handle structure known as a cursor. In a real application, we would typically avoid the error condition entirely by using the IF NOT EXISTS clause of the CREATE TABLE statement.) ...
https://dev.mysql.com/doc/internals/en/coding-style.html
Write SQL statements in the style of the MySQL Reference Manual SQL keywords and reserved words: uppercase Identifiers (table names, column names, etc.): lowercase Ignore this guideline if your intent is to check the processing of mixed lettercases ... Please have a look at the C/C++ coding guidelines and apply them when they make ...
https://dev.mysql.com/doc/internals/en/com-stmt-reset.html
COM_STMT_RESET resets the data of a prepared statement which was accumulated with COM_STMT_SEND_LONG_DATA commands and closes the cursor if it was opened with COM_STMT_EXECUTE The server will send a OK_Packet if the statement could be reset, a ...
https://dev.mysql.com/doc/internals/en/error-injection.html
This means each of them will never execute twice within one SQL statement. But if multiple non-VALUE macros are run through in a statement, each can execute once if they use distinct keywords. If not using the ERROR_INJECT macros in an expression, ... Note: The ERROR_INJECT framework has been removed in an early 6.0 ...
https://dev.mysql.com/doc/internals/en/event-flags.html
LOG_EVENT_SUPPRESS_USE_F = 0x8 (New in 4.1.7) Suppresses generation of a USE statement before the actual statement to be logged. Event headers for v3 format and up contain event flags in the two flag bytes at position FLAGS_OFFSET = 17. There are ...
https://dev.mysql.com/doc/internals/en/logging-transactions-definitions.html
(D-N-write) A statement makes an N-write if it makes any type of change to the server state that will not be changed by a ROLLBACK. Note: N-writes include updates to N-tables, but also CREATE and DROP statements. (D-log-target) Events are either ...
https://dev.mysql.com/doc/internals/en/mysql-server.html
dispatch_command Mysql-5.5 sql/sql_parse.cc:869 mysql_binlog_send Mysql-5.5 sql/sql_repl.cc:436 Mysql-5.6 sql/rpl_master.cc mysql_stmt_get_longdata Mysql-5.5 sql/sql_prepare.cc:2802 mysqld_stmt_prepare Mysql-5.5 sql/sql_prepare.cc:2165 ...Mysql-5.5 ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
SESSION_TRACK_SCHEMA Type Name Description string<lenenc> name name of the changed schema Example After a USE test statement: 01 05 04 74 65 73 74 ...test SESSION_TRACK_STATE_CHANGE A flag byte that indicates whether session state changes occurred.
https://dev.mysql.com/doc/internals/en/source-files-related-to-the-binary-log.html
rpl_utility.h /rpl_utility.cc: Contains auxiliary classes and functions used for Table_map_events, and also an auxiliary class for smart pointers sql_binlog.cc : Code to execute BINLOG statements (the base64-encoded values that mysqlbinlog prints ...
https://dev.mysql.com/doc/internals/en/transactions-data-layout.html
These members correspond to the statement and normal transactions respectively: thd->transaction.stmt contains a list of engines that are participating in the given statement thd->transaction.all contains a list of engines that have participated in ...Each element of the list contains a pointer to the storage engine, engine-specific transactional data, and engine-specific transaction ...