Python3 pymysql连接MySQL数据库

#!/usr/bin/python# -*- coding:utf8 -*-import pymysql#取得数据库连接对象conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='1234',db='python')#取得游标对象cur = conn.cursor()#插入数据cur.execute("INSERT INTO student(name,sex,age) VALUES('3', '0', '45')")conn.commit()#修改数据cur.execute("UPDATE student SET age = 90 WHERE id = 2" )conn.commit()#删除数据cur.execute("DELETE FROM student WHERE name = '3'")conn.commit()############################################    数据发生改变时一定要conn.commit()    #############################################查询数据cur.execute('SELECT *FROM student')for r in cur.fetchall():    print(r)cur.close()conn.close()