python操作MySQL

使用之前请先安装MySQLdb模块，可移步另一篇关于安装该模块的文章
#!/usr/bin/env python# This Python file uses the following encoding: utf-8import time, MySQLdb #连接 conn=MySQLdb.connect(host="localhost",user="root",passwd="",db="test",charset="utf8") cursor = conn.cursor() #写入 sql = "insert into user(name,created) values(%s,%s)" param = ("aaa",int(time.time())) n = cursor.execute(sql,param) print n #更新 sql = "update user set name=%s where id=3" param = ("bbb") n = cursor.execute(sql,param) print n #查询 n = cursor.execute("select * from user") for row in cursor.fetchall():  for r in row:  print r #删除 sql = "delete from user where name=%s" param =("aaa") n = cursor.execute(sql,param) print n cursor.close() #关闭 conn.close()
 写入数据时需要用conn.commit()