python-pymysql

1.基本用法

import pymysql#建立连接conn=pymysql.connect(    host='localhost',    port=3306,    user='root',    password='123456',    db='mydb')#创建游标cursor=conn.cursor()#执行sqleffect_row=cursor.execute("select * from student")#查询第一行#row_1=cursor.fetchone()#print(row_1)#查询全部row_all=cursor.fetchall()print(row_all)conn.commit()cursor.close()conn.close()