Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-versions.html
The latest version of Connector/ODBC supports all active MySQL Server versions, which today includes MySQL Server 8.0 and higher. As an example, use Connector/ODBC 9.3.0 with MySQL Server 8.0, 8.4, and 9.3. Information about each Connector/ODBC ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errorcode.html
This module contains both MySQL server and client error codes defined as module attributes with the error number as value. >>> from mysql.connector import errorcode >>> errorcode.ER_BAD_TABLE_ERROR 1051 For more information about MySQL errors, see ...Using error codes instead of error numbers could make reading the source code a bit ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-client-flags.html
Syntax: >>> cnx.client_flags=flags >>> cnx.clieng_flags This property sets the client flags to use when connecting to the MySQL server, and returns the set value as an integer. For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from ...The flags value can be either an integer or a sequence of valid client flag values (see Section 6.9.7, “constants.ClientFlag ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-set-client-flags.html
Syntax: cnx.set_client_flags(flags) This method sets the client flags to use when connecting to the MySQL server, and returns the new value as an integer. For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from ...The flags argument ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-start-transaction.html
MySQL ignores this for isolation levels for which that option does not apply. If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. It accepts arguments indicating whether to ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-add-attribute.html
Syntax: cursor.add_attribute(name, value) Adds a new named query attribute to the list, as part of MySQL server's Query Attributes functionality. value: a value converted to the MySQL Binary Protocol, similar to how prepared statement parameters ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-description.html
Each tuple in the list contains values as follows: (column_name, type, None, None, None, None, null_ok, column_flags) The following example shows how to interpret description tuples: import mysql.connector from mysql.connector import FieldType ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor.html
The MySQLCursor class instantiates objects that can execute operations such as SQL statements. Cursor objects interact with the MySQL server using a MySQLConnection object. To create a cursor, use the cursor() method of a connection object: import ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffered.html
After executing a query, a MySQLCursorBuffered cursor fetches the entire result set from the server and buffers the rows. MySQLCursorBuffered can be useful in situations where multiple queries, with small result sets, need to be combined or computed ...For queries executed using a buffered cursor, row-fetching methods such as fetchone() return rows from the set of buffered ...
https://dev.mysql.com/doc/connectors/en/connector-python-obtaining.html
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 interfaces to both the X and classic protocols. Using pip is the preferred method to ...