python数据库execute返回值_python使用mysqldb连接数据库操作方法示例详解

代码如下:

# -*- coding: utf-8 -*-

#mysqldb

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 = cur