Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-programmingerror.html
The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") except mysql.connector.ProgrammingError as err: if err.errno == errorcode.ER_SYNTAX_ERROR: print("Check your syntax!") else: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-add-connection.html
If this argument is missing, the pool creates a new connection and adds it. Syntax: cnxpool.add_connection(cnx = None) This method adds a new or existing MySQLConnection to the pool, or raises a PoolError if the pool is full. Arguments: cnx: The ...
https://dev.mysql.com/doc/connector-python/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/connector-python/en/connector-python-api-mysqlcursor-constructor.html
If omitted, the cursor is created but its execute() method raises an exception.
https://dev.mysql.com/doc/connector-python/en/connector-python-versions.html
Python terminology regarding distributions: Built Distribution: A package created in the native packaging format intended for a given platform. This section describes both version releases, such as 8.0.34, along with notes specific to the two ...
https://dev.mysql.com/doc/connector-python/en/differences-between-binary-and-source-distribution.html
Note Creating a wheel package from an sdist may fail for some older Python version, as the Connector/Python source code is only compatible with a specific subset of Python versions. Installing from a wheel (bdist package) is the recommended, except ...
https://dev.mysql.com/doc/internals/en/additional-accessors-for-plugins.html
Starting with MySQL 5.1.21 the following additional accessors are made available to all plug-ins: Full definition of MYSQL_LEX_STRING (identical to LEX_STRING from m_string.h) Full definition of MYSQL_XID (binary compatible with XID from handler.h) ...
https://dev.mysql.com/doc/internals/en/binlog-version.html
Depending on the MySQL Version that created the binlog the format is slightly different.