当前位置：Gxlcms > 数据库问题 > 【mysql】MySQLdb返回字典方法

【mysql】MySQLdb返回字典方法

时间：2021-07-01 10:21:17 帮助过：29人阅读

MySQLdb import MySQLdb.cursors conn = MySQLdb.Connect ( host = ‘localhost‘, user = ‘root‘ , passwd = ‘‘, db = ‘test‘, compress = 1, cursorclass = MySQLdb.cursors.DictCursor, charset=‘utf8‘) // <- important cursor = conn.cursor() cursor.execute ("SELECT name, txt FROM table") rows = cursor.fetchall() cursor.close() conn.close()

for row in rows：
print row [‘name‘], row [‘txt‘] # bingo!

# another (even better) way is:

conn = MySQLdb . Connect (
host = ‘ localhost ‘, user = ‘root‘ ,
passwd = ‘‘, db = ‘test‘ , compress = 1)
cursor = conn.cursor (cursorclass = MySQLdb.cursors.DictCursor)
# ...
# results by field name
cursor = conn.cursor()
# ...
# ...results by field number

注意：如果同时安装了PyMySQL和MySQL-python库，会导致MySQL-python失效，只有pymsql可用

【mysql】MySQLdb返回字典方法

标签：row etc ber 字典 table number test 维护 com

【mysql】MySQLdb返回字典方法

人气教程排行