Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-get-attributes.html
Syntax: cursor.get_attributes() Return a list of existing query attributes, as set by Section 6.9.5.2, “MySQLCursor.add_attribute() Method”.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-lastrowid.html
Syntax: id = cursor.lastrowid This read-only property returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement or None when there is no such value available. For example, if you perform an INSERT into a ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-statement.html
Syntax: str = cursor.statement This read-only property returns the last executed statement as a string. The statement property can be useful for debugging and displaying what was sent to the MySQL server. The string can contain multiple statements ...
https://dev.mysql.com/doc/connectors/en/connector-python-opentelemetry.html
OracleMySQLInstrumentor().instrument() with tracer.start_as_current_span("client_app"): with mysql.connector.connect(**config) as cnx: with cnx.cursor() as cur: cur.execute("SELECT @@version") _ = cur.fetchall() Morphology of the Emitted Traces A ...
https://dev.mysql.com/doc/connectors/en/connector-python-reference.html
mysql.connector errorcode errors connection constants conversion cursor dbapi locales eng client_error protocol utils . Examples should be considered working for Python 2.7, and Python 3.1 and greater. They might also work for older versions (such ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html
Figure 5.4 Connector/ODBC Connect Options Dialog Toggling the Details button opens (or closes) an additional tabbed display where you set additional options that include the following: Connections, Metadata, and Cursors/Results enable you to select ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
The GetChunk() and AppendChunk() methods from ADO do not work as expected when the cursor location is specified as adUseServer. The following section details some common errors and their suggested fix or alternative solution. If you are still ...
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-mysqlconnection-commit.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.commit() To roll back instead and discard modifications, see the rollback() method. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...