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-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/connector-python/en/connector-python-api-mysqlcursor-nextset.html
This method can be used as part of the multi statement execution workflow. Syntax: row = cursor.nextset() This method makes the cursor skip to the next available set, discarding any remaining rows from the current set. It returns None if there are ...
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-api-mysqlcursorbuffered.html
In this case, you must be sure to fetch all rows of the result set before executing any other statements on the same connection, or an InternalError (Unread result found) exception will be raised. After executing a query, a MySQLCursorBuffered ...
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-example-cursor-select.html
In the preceding example, we store the SELECT statement in the variable query. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees hired in the year 1999 ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/internals/en/binlog-version.html
Depending on the MySQL Version that created the binlog the format is slightly different.
https://dev.mysql.com/doc/internals/en/client-directory.html
The client library includes mysql.cc (the source of the mysql executable) and other utilities. Most of the utilities are mentioned in the MySQL Reference Manual. Generally these are standalone C programs which one runs in "client mode", that is, ...