Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-column-names.html
Syntax: sequence = cursor.column_names This read-only property returns the column names of a result set as sequence of Unicode strings.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-description.html
Syntax: tuples = cursor.description This read-only property returns a list of tuples describing the columns in a result set. Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The ...
https://dev.mysql.com/doc/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorprepared.html
In MySQL, there are two ways to execute a prepared statement: Use the PREPARE and EXECUTE statements. To repeatedly execute the same statement with different data for different executions, this is more efficient than using PREPARE and EXECUTE. For ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-pooledmysqlconnection.html
This class is used by MySQLConnectionPool to return a pooled connection instance. It is also the class used for connections obtained with calls to the connect() method that name a connection pool (see Section 6.8.5, “Connector/Python Connection ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-sqlmode.html
It is mostly used when setting the SQL modes at connection time using the connection's sql_mode property.
https://dev.mysql.com/doc/connectors/en/connector-python-installation-source.html
Source distributions are packaged in two formats: Zip archive format (.zip file) Compressed tar archive format (.tar.gz file) Either of the two packaging formats can be used on any platforms, but Zip archives are more commonly used on Windows ...
https://dev.mysql.com/doc/connectors/en/connector-python-logging.html
By default, logging functionality follows the default Python logging behavior. If logging functionality is not configured, only events with a severity level of WARNING and greater are printed to sys.stderr. For related information, see Python's ...
https://dev.mysql.com/doc/connectors/en/connector-python-obtaining.html
Using pip is the preferred method to obtain, install, and upgrade Connector/Python. Note The mysql-connector-python package installs an interface to the classic MySQL protocol. Prior to Connector/Python 8.3.0, mysql-connector-python installed ...