安装
pip install pymysql
插入
import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('insert into Person (Name,Age) values (\"{}\",{})'.format('你是谁',33))
cursor.close()
conn.commit()
conn.close()
print('end')
修改
import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('update Person set Name="{}\",Age={} where id=31'.format('哈哈哈',44))
cursor.close()
conn.commit()
conn.close()
print('end')
删除
import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('delete from Person where id=31')
cursor.close()
conn.commit()
conn.close()
print('end')
查询
import pymysql
conn = pymysql.connect(host='ip',user="root",passwd="pwd",db="dbname")
cursor=conn.cursor()
cursor.execute('select * from Person')
while 1:
res=cursor.fetchone()
if res is None:
#表示已经取完结果集
break
print (res)
cursor.close()
conn.commit()
conn.close()
print('end')
