Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-query-iter.html
Syntax: cnx.cmd_query_iter(statement) Similar to the cmd_query() method, but returns a generator object to iterate through results. Use cmd_query_iter() when sending multiple statements, and separate the statements with semicolons. The following ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html
This method sends a COMMIT statement to the MySQL server, committing the current transaction. Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-rollback.html
This method sends a ROLLBACK statement to the MySQL server, undoing all data changes from the current transaction. By default, Connector/Python does not autocommit, so it is possible to cancel transactions when using transactional storage engines ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = cursor.execute(operation, params=None, multi=True) This method executes the given database operation (query or ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-lastrowid.html
Syntax: id = cursor.lastrowid This read-only property returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement or None when there is no such value available. For example, if you perform an INSERT into a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...
MySQL Connector/Python Developer Guide :: 4.5 Installing Connector/Python from a Source Distribution
https://dev.mysql.com/doc/connector-python/en/connector-python-installation-source.html
The Connector/Python source distribution is platform independent, and is packaged in the compressed tar archive format (.tar.gz file). Prerequisites for Compiling Connector/Python with the C Extension Source distributions include the C Extension ...
https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html
MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For notes detailing the changes in each release of Connector/Python, see MySQL ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Connector/Python can execute either a single or multiple statements, this section references multiple statement and associated delimiter support. Note Before Connector/Python 9.2.0, the multi option was required to execute multiple statements. with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...