python连接数据库步骤_python操作数据库的步骤

操作数据库的流程、方法各种语言都是差不错的思路

在python中的操作流程：

import time, MySQLdb

#先连接数据库

conn=MySQLdb.connect(host="192.168.2.113",user="root",passwd="123",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()