Search Results
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.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchmany.html
You must fetch all rows for the current query before executing new statements using the same connection. Syntax: rows = cursor.fetchmany(size=1) This method fetches the next set of rows of a query result and returns a list of tuples. If no more ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html
Syntax: row = cursor.fetchone() This method retrieves the next row of a query result set and returns a single sequence, or None if no more rows are available. By default, the returned tuple consists of data returned by the MySQL server, converted ...