python操作MySQL

1. 使用之前请先安装MySQLdb模块，可移步另一篇关于安装该模块的文章
   #!/usr/bin/env python
   # This Python file uses the following encoding: utf-8
   
   import 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()