Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-client-flags.html
For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from mysql.connector.constants import ClientFlag >>> cnx.client_flags=[ClientFlag.FOUND_ROWS, -ClientFlag.LONG_FLAG] >>> cnx.reconnect() Note Client flags are only set or used when ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-cmd-refresh.html
Example: >>> from mysql.connector import RefreshOption >>> refresh = RefreshOption.LOG | RefreshOption.THREADS >>> cnx.cmd_refresh(refresh) . This method flushes tables or caches, or resets replication server information. The options argument should ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html
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 transactional storage engines. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-set-client-flags.html
For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from mysql.connector.constants import ClientFlag >>> cnx.set_client_flags([ClientFlag.FOUND_ROWS, -ClientFlag.LONG_FLAG]) >>> cnx.reconnect() Note Client flags are only set or used ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-sql-mode.html
>>> cnx.sql_mode = 'TRADITIONAL,NO_ENGINE_SUBSTITUTION' >>> cnx.sql_mode.split(',') [u'STRICT_TRANS_TABLES', u'STRICT_ALL_TABLES', u'NO_ZERO_IN_DATE', u'NO_ZERO_DATE', u'ERROR_FOR_DIVISION_BY_ZERO', u'TRADITIONAL', u'NO_AUTO_CREATE_USER', ... This ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor.html
To create a cursor, use the cursor() method of a connection object: import mysql.connector cnx = mysql.connector.connect(database='world') cursor = cnx.cursor() Several related classes inherit from MySQLCursor. The MySQLCursor class instantiates ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbuffered.html
Example: import mysql.connector cnx = mysql.connector.connect() # Only this particular cursor will buffer results cursor = cnx.cursor(buffered=True) # All cursors created from cnx2 will be buffered by default cnx2 = ...After executing a query, a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorraw.html
Example: import mysql.connector cnx = mysql.connector.connect() # Only this particular cursor will be raw cursor = cnx.cursor(raw=True) # All cursors created from cnx2 will be raw by default cnx2 = mysql.connector.connect(raw=True) . A ...
https://dev.mysql.com/doc/connector-python/en/connector-python-cext-development.html
If the C extension is not available on the system then use_pure is True. On Linux, the C and Python implementations are available as different packages. You can install one or both implementations on the same system. For Connector/Python ...