Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-get-warnings.html
>>> cnx.get_warnings = True >>> cursor.execute('SELECT "a"+1') >>> cursor.fetchall() [(1.0,)] >>> cursor.fetchwarnings() [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: 'a'")] Returns True or False. This property can be assigned a value of ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-raise-on-warnings.html
The following example shows the execution of a query that produces a warning: >>> cnx.raise_on_warnings = True >>> cursor.execute('SELECT "a"+1') >>> cursor.fetchall() .. This property can be assigned a value of True or False to enable or disable ...
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-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/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-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html
The connect() constructor creates a connection to the MySQL server and returns a MySQLConnection object. The following example shows how to connect to the MySQL server: import mysql.connector cnx = mysql.connector.connect(user='scott', ...
https://dev.mysql.com/doc/connector-python/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/internals/en/autotools-plugin-macros.html
If the named plugin is selected, it will in turn enable all its dependencies. The following macros enable plugin support in the autotools configuration files. Declaring a plugin: MYSQL_PLUGIN(name, long-name, description [,configlist]) Each plugin ...
https://dev.mysql.com/doc/internals/en/charsets.html
Character sets are used by MySQL when storing information, both to ensure that the information is stored (and returned) in the correct format, but also for the purposes of collation and sorting. Each character set supports one or more collations, ...