mysql.cursor python_MySQL Python教程（4）

Class cursor.MySQLCursorBuffered

该类从Class cursor.MySQLCursorBuffered继承，如果需要，可以在执行完SQL语句后自动缓冲结果集合。

import mysql.connector

cnx = mysql.connector.connect()

# Only this particular cursor will buffer results

cnx.cursor(buffered=True)

# All cursors will be buffering by default

cnx2 = mysql.connector.connect(buffered=True)

Class cursor.MySQLCursorPrepared

该类继承cursor.MySQLCursor，使用二进制协议执行prepare statement

使用方法：

import mysql.connector

from mysql.connector.cursor import MySQLCursorPrepared

cnx = mysql.connector.connect(database='employees')

cursor = cnx.cursor(cursor_class=MySQLCursorPrepared)

此时cursor为MySQLCursorPrepared对象。

举例：

cursor = cnx.cursor(cursor_class=MySQLCursorPrepared)

stmt = "SELECT fullname FROM em