python操作mysql

两个对mysql的操作，原理一样

import pymysql
db=pymysql.connect(host='localhost',user='root',password='123456',db='student')
cursor=db.cursor()
cursor.execute('insert into course(course_id,title,dept_name,credits) values ("cs_1013","模电","计算机科学系","4.5")')
db.commit()
cursor.close()
db.close()

con=pymysql.connect(host='localhost',user='root',password='123456',db='student')
#写成 con=pymysql.connect("localhost","user","password","db")只适用于老版本，新版本不适用，会报错！！！
cs1=con.cursor()
cs1.execute('update course set title="高数" where course_id="cs_1001"')
con.commit()#提交
cs1.close()
con.close()

最后一定要进行commit()操作，不然mysql中无法查询到更新的数据

记得将cursor游标对象，和con连接进行close()