Method MySQLCursor.executemany(operation, seq_params)
數(shù)據(jù)庫操作operation會執(zhí)行多次，直至seq_params中所有參數(shù)執(zhí)行完畢。
data = [
('Jane', date(2005, 2, 12)),
('Joe', date(2006, 5, 23)),
('John', date(2010, 10, 3)),
]
stmt = "INSERT INTO employees (first_name, hire_date) VALUES (%s, %s)"
cursor.executemany(stmt, data)
Method MySQLCursor.fetchall()
返回查詢的結(jié)果集合。
>>> cursor.execute("SELECT * FROM employees ORDER BY emp_no")
>>> head_rows = cursor.fetchmany(size=2)
>>> remaining_rows = cursor.fetchall()
Method MySQLCursor.fetchmany(size=1)
返回接下來的size個查詢結(jié)果，如果沒有足夠的結(jié)果，則返回空的list。
Method MySQLCursor.fetchone()
返回接下來的一個查詢結(jié)果，該函數(shù)在fetchamany()和fetchalll()中調(diào)用。
Property MySQLCursor.column_names
只讀屬性。返回一個Unicode編碼的string，為結(jié)果集合的列名稱。
cursor.execute("SELECT last_name, first_name, hire_date "
"FROM employees WHERE emp_no = %s", (123,))
row = dict(zip(cursor.column_names, cursor.fetchone())
print("{last_name}, {first_name}: {hire_date}".format(row))
cursor.MySQLCursorDict Class用法(繼承自MySQLCursor,返回每行的字典)
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("* {Name}".format(Name=row['Name']
也可以通過format來訪問
cursor.execute("SELECT Name, Population FROM country WHERE Continent = 'Europe'")
print("Countries in Europe with population:")
for row in cursor:
print("* {Name}: {Population}".format(**row))
cursor.MySQLCursorRaw Class(行號游標)
import mysql.connector
cnx = mysql.connector.connect()
# Only this particular cursor will be raw
cursor = cnx.cursor(raw=True)
# All cursors created from cnx2 will be raw by default
cnx2 = mysql.connector.connect(raw=True)
cursor.MySQLCursorNamedTuple（行元組）
cnx = mysql.connector.connect(database='world')
cursor = cnx.cursor(named_tuple=True)
cursor.execute("SELECT * FROM country WHERE Continent = 'Europe'")
print("Countries in Europe with population:")
for row in cursor:
print("* {Name}: {Population}".format(
Name=row.Name,
Population=row.Population
))