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就是结果集,是元祖类型