Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 5.10 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/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. A connection with the MySQL server can be established using either the mysql.connector.connect() ...
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-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
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.