python實現簡單資料庫連接及操作__資料庫

import MySQLdb'''import pymysqlpymysql：pymsql是Python中操作MySQL的模組，其使用方法和MySQLdb幾乎相同。但目前pymysql支援python3.x而後者不支援3.x版本'''conn= MySQLdb.connect(        host='localhost',        port = 3306,        user='root',        passwd='123456',        db ='test',        )cur = conn.cursor()#建立資料表cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")#插入一條資料cur.execute("insert into student values('2','Tom','3 year 2 class','9')")#修改查詢條件的資料cur.execute("update student set class='3 year 1 class' where name = 'Tom'")#刪除查詢條件的資料cur.execute("delete from student where age='9'")cur.close()conn.commit()conn.close()