Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
This example inserts information about a new employee, then selects the data for that person. Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
Call the commit() method of the MySQLConnection instance within your application after doing a set of related insert, update, and delete operations. A connection with the MySQL server can be established using either the mysql.connector.connect() ...
https://dev.mysql.com/doc/internals/en/dbug-sleep.html
In cases where the normal server code does not have a block point at the critical place, one can insert an artificial synchronization point. open_tables(...) DBUG_EXECUTE_IF("sleep_open_and_lock_after_open", { const char *old_proc_info= ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
MySQL supports a Debug Sync Facility, which - in spite of the "debug" in its name - is completely independent from the DBUG facility (except that it uses DBUG to trace its operation, if DBUG is also configured in the server). The documentation here ...
https://dev.mysql.com/doc/internals/en/error-flags.html
(This allows one to catch all error messages generated by a statement) thd->lex->current_select->no_error This is set to in case likes INSERT IGNORE ... thd->count_cuted_fields If set, we generate warning for field conversations (normal case for ...
https://dev.mysql.com/doc/internals/en/myisam-dynamic-data-file-layout.html
When a record is inserted after this, it reuses the old frame. The rest is inserted in other old frames, or, if non is available, in a new frame at end of file. A record can be put in one or more frames, also called the record "parts" or "blocks".
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that ...