Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchwarnings.html
The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> cursor.fetchwarnings() [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: ...Syntax: tuples = cursor.fetchwarnings() This method returns a list of tuples containing warnings generated by the previously executed ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-warnings.html
The following example shows a SELECT statement that generates a warning: >>> cnx.get_warnings = True >>> cursor.execute("SELECT 'a'+1") >>> cursor.fetchall() [(1.0,)] >>> print(cursor.warnings) [(u'Warning', 1292, u"Truncated incorrect DOUBLE value: ... Syntax: tuples = cursor.warnings This property returns a list of tuples containing warnings generated by the previously executed ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
This dictionary is passed to the execute() method of the cursor object if an error occurred. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the ...
https://dev.mysql.com/doc/connector-python/en/connector-python-option-files.html
The resulting connection uses cpyapp_dev as the default database, not cpyapp: cnx2 = mysql.connector.connect(option_files='/etc/mysql/connectors.cnf', database='cpyapp_dev') Connector/Python raises a ValueError if an option file cannot be read, or ...(For general information about option files in MySQL, see Using Option Files.) Two arguments for the connect() call control use of option files in Connector/Python programs: option_files: Which option files to ...
https://dev.mysql.com/doc/connector-python/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/internals/en/binary-log-overview.html
[Some information in this section is derived from Chapter 20, The Binary Log, in the MySQL Reference Manual.] The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. The log is enabled ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support Compression . To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's ...
https://dev.mysql.com/doc/internals/en/com-debug.html
COM_DEBUG: dump debug info to stdout Returns EOF_Packet or ERR_Packet on error Payload 1 [0d] COM_DEBUG . COM_DEBUG triggers a dump on internal debug info to stdout of the mysql-server.
https://dev.mysql.com/doc/internals/en/debug-sync-activation-deactivation.html
The Debug Sync facility is an optional part of the MySQL server. The Debug Sync Facility, when compiled in, is disabled by default. To enable it, start mysqld with the --debug-sync-timeout[=N] option, where N is a timeout value greater than 0. N ...
https://dev.mysql.com/doc/internals/en/event-flags.html
Event headers for v3 format and up contain event flags in the two flag bytes at position FLAGS_OFFSET = 17. There are comments about these flags in log_event.h, in addition to the remarks in this section. Current event flags: ...