python功能强大,第三方库很多。今天记录一下操作数据库的库 pymysql
#coding=utf-8 import pymysql conn = pymysql.connect(host="hostip",port=3306,user='root',passwd=password',db='mydb') cursor = conn.cursor() sql = 'select * from mytable' cursor.execute(sql) row = cursor.fetchall()
conn.commit() cursor.close() conn.close()
这样返回的row就是结果集,是元祖类型