Search Results
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.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-use-unicode.html
This property sets and returns whether the connection uses Unicode with the value True or False. # gets whether the connector returns string fields as unicode or not print(cnx.use_unicode) >> True # set or update use_unicode property ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-user.html
This read-only property returns the user name used for connecting to the MySQL server.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-pool-name.html
Syntax: cnxpool.pool_name This property returns the connection pool name. Example: name = cnxpool.pool_name ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool.html
This class provides for the instantiation and management of connection pools.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-add-attribute.html
A warning is logged when setting query attributes server connection that does not support them. Syntax: cursor.add_attribute(name, value) Adds a new named query attribute to the list, as part of MySQL server's Query Attributes functionality. name: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-close.html
This method closes the cursor, resets all results, and ensures that the cursor object has no reference to its original connection object. Syntax: cursor.close() Use close() when you are done using a cursor.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html
Before Connector/Python 9.2.0, execute() accepted a multi option and returned an iterator if set to True. If the connection is configured to fetch warnings, warnings generated by the operation are available through the MySQLCursor.fetchwarnings() ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchall.html
Syntax: rows = cursor.fetchall() The method fetches all (or all remaining) rows of a query result set and returns a list of tuples. If no more rows are available, it returns an empty list.