Search Results
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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. Consider using the MySQL sql_mode setting for turning warnings into errors. A connection with the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
Code First Features Following are new Code First features supported by Connector/NET: Code First Mapping to Insert/Update/Delete Stored Procedures supported: modelBuilder.Entity<EntityType>().MapToStoredProcedures(); Idempotent migrations scripts ...
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. Consider using the MySQL sql_mode setting for turning warnings into errors. A connection with the ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
That is, if an INSERT fires a trigger, which calls a stored procedure, that invokes a stored method, and so forth, all tables used in the trigger, stored procedure, method, etc., are locked in the beginning of the INSERT. MySQL calls ...
https://dev.mysql.com/doc/internals/en/unsafe-statements.html
NOTE: the following list is incomplete; it does not take into account changes made in 2010 or later (roughly). INSERT DELAYED, since the rows inserted may interleave with concurrently executing statements. An unsafe statement will be logged in row ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-basic.html
It demonstrates how to perform insert, read, and update operations, using both inline value buffers as well as read and write methods. Shows insert, read, and update, using both inline value buffer and read/write methods. Use piece-wise read/write ... This example illustrates the manipulation of a blob column in the NDB ...