Syntax:
cursor = cnx.cursor([arg=value[, arg=value]...]) This method returns aMySQLCursor() object, or a subclass of it depending on the passed arguments. The returned object is acursor.CursorBase instance. For more information about cursor objects, seeSection 10.5, “cursor.MySQLCursor Class”, andSection 10.6, “Subclasses cursor.MySQLCursor”.
Arguments may be passed to thecursor() method to control what type of cursor to create:
If
bufferedisTrue, the cursor fetches all rows from the server after an operation is executed. This is useful when queries return small result sets.bufferedcan be used alone, or in combination with thedictionaryargument.bufferedcan also be passed toconnect()to set the default buffering mode for all cursors created from the connection object. SeeSection 7.1, “Connector/Python Connection Arguments”.For information about the implications of buffering, seeSection 10.6.1, “cursor.MySQLCursorBuffered Class”.
If
rawisTrue, the 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.rawcan also be passed toconnect()to set the default raw mode for all cursors created from the connection object. SeeSection 7.1, “Connector/Python Connection Arguments”.If
dictionaryisTrue, the cursor returns rows as dictionaries. This argument is available as of Connector/Python 2.0.0.If
preparedisTrue, the cursor is used for executing prepared statements. This argument is available as of Connector/Python 1.1.2. The C extension supports this as of Connector/Python 8.0.17.The
cursor_classargument can be used to pass a class to use for instantiating a new cursor. It must be a subclass ofcursor.CursorBase.
The returned object depends on the combination of the arguments. Examples:
If not buffered and not raw:
MySQLCursorIf buffered and not raw:
MySQLCursorBufferedIf not buffered and raw:
MySQLCursorRawIf buffered and raw:
MySQLCursorBufferedRaw