Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-in-transaction.html
This property returns True or False to indicate whether a transaction is active for the connection. >>> cnx.start_transaction() >>> cnx.in_transaction True >>> cnx.commit() >>> cnx.in_transaction False in_transaction was added in MySQL ...The value ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-reset-session.html
Syntax: cnx.reset_session(user_variables = None, session_variables = None) Resets the connection by reauthenticating to clear the session state. Example: user_variables = {'var1': '1', 'var2': '10'} session_variables = {'wait_timeout': 100000, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-server-host.html
This read-only property returns the host name or IP address used for connecting to the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-server-info.html
This read-only property returns the MySQL server information verbatim as a string: for example 8.4.0-log, or None when not connected.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-server-port.html
This read-only property returns the TCP/IP port used for connecting to the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-server-version.html
This read-only property returns the MySQL server version as a tuple, or None when not connected.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-sql-mode.html
This property is used to retrieve and set the SQL Modes for the current connection. >>> cnx.sql_mode = 'TRADITIONAL,NO_ENGINE_SUBSTITUTION' >>> cnx.sql_mode.split(',') [u'STRICT_TRANS_TABLES', u'STRICT_ALL_TABLES', u'NO_ZERO_IN_DATE', ...The value ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-start-transaction.html
If the value is True, Connector/Python sends WITH CONSISTENT SNAPSHOT with the statement. If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. To determine whether a ...It ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-time-zone.html
This property is used to set or retrieve the time zone session variable for the current connection. >>> cnx.time_zone = '+00:00' >>> cursor = cnx.cursor() >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() (datetime.datetime(2012, 6, 15, 11, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-unix-socket.html
This read-only property returns the Unix socket file for connecting to the MySQL server.