Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
Installing Connector/Python also installs the mysql.connector.aio package that integrates asyncio with the connector to allow integrating asynchronous MySQL interactions with an application. Functions included in the asyncio API must be used to ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
You use the SQL INSERT, UPDATE, and DELETE statements to update different items concurrently, writing only the changed values to disk. The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-authentication.html
MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a user. Pluggable authentication enables the server to determine which plugin applies, based on the user name and host name that your ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-example.html
Insert the following code into the existing Program.cs file, replacing the default C# code. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database. MySQL ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if needed. The MySqlCommand class ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql-custom-listeners.html
To build custom listeners that work with the MySQL Connector/NET Trace Source, it is necessary to understand the key methods used, and the event data formats used. The main method involved in passing trace messages is the TraceSource.TraceEvent ...
https://dev.mysql.com/doc/connector-net/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-architecture.html
The database is used as the source of the data (during queries) and the destination for data (during inserts and updates). The Connector/ODBC architecture is based on five components, as shown in the following diagram: Figure 3.1 Connector/ODBC ...