Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
To change the current database later, execute a USE SQL statement or set the database property of the MySQLConnection instance. This technique is preferred over using the SET NAMES SQL statement directly. A connection with the MySQL server can be ...
https://dev.mysql.com/doc/internals/en/automatic-trace-purging.html
Thus, if a statement contains substatements (example: invokes stored procedures, stored functions, triggers), the top statement and substatements each generate one trace, but at the execution's end only the last substatement's trace is visible. A ...
https://dev.mysql.com/doc/internals/en/capability-flags.html
CLIENT_MULTI_STATEMENTS Value 0x00010000 Server Can handle multiple statements per COM_QUERY and COM_STMT_PREPARE. The capability flags are used by the client and server to indicate which features they support and want to use. Value 0x00000001 ...
https://dev.mysql.com/doc/internals/en/com-stmt-close.html
COM_STMT_CLOSE deallocates a prepared statement No response is sent back to the client. COM_STMT_CLOSE: COM_STMT_CLOSE direction: client -> server response: none payload: 1 [19] COM_STMT_CLOSE 4 statement-id example: 05 00 00 00 19 01 00 00 00 ...
https://dev.mysql.com/doc/internals/en/cs-sect-expired-password.html
All other statements fail with an error like this: mysql> SELECT 1; ERROR 1820 (HY000): You must SET PASSWORD before executing this statement On the protocol side exists a safeguard CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS to protect clients from running ... Since MySQL 5.6.7, a MySQL account can be expired with ALTER USER account PASSWORD ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The master/server relationships look like this: M1---->M2 ^ | | | +--M3<-+ A client sends an INSERT statement to M1. The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and up). The first 19 bytes for v4 ...
https://dev.mysql.com/doc/internals/en/implementing-commit.html
The THD parameter is used to identify the transaction that needs to be committed, while the bool all parameter indicates if this is a full transaction commit or just the end of a statement that is part of the transaction. If the server is in ...
https://dev.mysql.com/doc/internals/en/implementing-external-lock-method.html
The [custom-engine.html#custom-engine-api-reference-external_lock external_lock()] method is called at the start of a statement or when a LOCK TABLES statement is issued. Examples of using external_lock() can be found in the sql/ha_innodb.cc file, ...
https://dev.mysql.com/doc/internals/en/information-schema-optimizer-trace-table.html
TRACE: The trace, in JSON format (see json.org: basically it has scalars (number, string, bool) and structures (either arrays or associative arrays)).
https://dev.mysql.com/doc/internals/en/item-class.html
To us, the word Item means more than just “thingamabob”; it is a technical term with a precise definition in the context of our source code. In the function category we include operators such as + and ||, because operators are merely functions ...