Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
From this SELECT statement the Command Builder can work out the corresponding INSERT, UPDATE and DELETE statements that would be required to update the database. Instantiating a MySqlCommandBuilder Object Once the MySqlDataAdapter has been created, ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result set scrolling. Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 7.6 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...For the complete ODBC API reference, please refer to the ODBC Programmer's Reference at ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-affected-rows.html
Syntax: count = ccnx.affected_rows() Returns the number of rows changed, inserted, or deleted by the most recent UPDATE, INSERT, or DELETE statement.
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 ...