Python操作MySQL
# coding=utf-
import MySQLdb
#查询数量 def Count(cur):count=cur.execute( ‘select * from Student‘ )
print ‘there has %s rows record‘ % count
#插入 def Insert(cur):
sql = "insert into Student(ID,Name,Age,Sex)values(%s,%s,%s,%s)"
param = ( , ‘xiaoming‘ , , ‘boy‘ )
cur.execute(sql,param)
#查询 def Select(cur):n = cur.execute( "select * from Student" )
print "------"
for row in cur.fetchall():
for r in row:
print r
print "------"
#更新 def Update(cur):sql = "update Student set Name = %s where ID = 2"
param = ( "xiaoxue" )
count = cur.execute(sql,param)
#删除 def Delete(cur):sql = "delete from Student where Name = %s"
param =( "xiaoxue" )
n = cur.execute(sql,param)
try :
conn=MySQLdb.connect(host= ‘localhost‘ ,user= ‘root‘ ,passwd= ‘123456‘ ,db= ‘python‘ ,port= )
cur=conn.cursor()
#数量
Count(cur)
#查询
Select(cur)
#插入
Insert(cur)
print "插入之后"
#查询
Select(cur)
#更新
Update(cur)
print "更新之后"
#查询
Select(cur)
#删除
Delete(cur)
print "删除之后"
#查询
Select(cur)
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[ ], e.args[ ])
- 本文来自：Linux教程网
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
