Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorraw.html
A MySQLCursorRaw cursor skips the conversion from MySQL data types to Python types when fetching rows. A raw cursor is usually used to get better performance or when you want to do the conversion yourself. To create a raw cursor, use the raw ...
https://dev.mysql.com/doc/connectors/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/connectors/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursordict.html
Example: cnx = mysql.connector.connect(database='world') cursor = cnx.cursor(dictionary=True) cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'") print("Countries in Europe:") for row in cursor: print("* ...The keys for each ...
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
(A buffered cursor fetches and buffers the rows of a result set after executing a query; see Section 6.9.6.1, “cursor.MySQLCursorBuffered Class”.) This way, it is unnecessary to fetch the rows in a new variables. The following example script ...
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-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursordict.html
Example: cnx = mysql.connector.connect(database='world') cursor = cnx.cursor(dictionary=True) cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'") print("Countries in Europe:") for row in cursor: print("* ...The keys for each ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
(A buffered cursor fetches and buffers the rows of a result set after executing a query; see Section 10.6.1, “cursor.MySQLCursorBuffered Class”.) This way, it is unnecessary to fetch the rows in a new variables. The following example script ...
https://dev.mysql.com/doc/refman/8.4/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...