怎样用python操作mysql数据库?

alpa 2004-06-23 04:16:13

怎样用python操作mysql数据库?如果有例子,请给出了参考一下.

...全文

528 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

hf1414 2004-07-04

打赏
举报

zhaoweikid 2004-06-26

打赏
举报

Programming Python
Python Cookbook里都有例子的

invalid 2004-06-25

打赏
举报

上面的是mysql的linux平台下的模块。
安装看tar解压缩后的README。
例子：从一个库倒数据到另外一个库的代码
import MySQLdb
import pprint
import sys
import os
import string

db_host = "127.0.0.1"
db_name = "wap"
db_name2 = "wap2"
db_user = "userx"
db_user_passwd ="passx"

try:
db = MySQLdb.connect(db_host, db_user, db_user_passwd, db_name)
db2 = MySQLdb.connect(db_host, db_user, db_user_passwd, db_name2)
except MySqlDb.OperationalError,error:
print "Error:",error
sys.exit( 1)
else:
c = db.cursor()
e = db2.cursor()
sqlcolumn = ''' CorpId, UserId ,ParentId , UserNo ,UserName, FullName,RegPhone,Passwd ,NodeType ,Status ,AreaCode ,TelePhone ,Fax,EMail,CreateTime,ModifyTime '''
sqlwhere = ''' where unix_timestamp(ModifyTime) >= unix_timestamp(now()) - 28830 '''
sql = '''select ''' + sqlcolumn + ''' from ESM_GroupUser ''' + sqlwhere;

try:
c.execute(sql)

except MySqlDb.OperationalError,error:
print "Error:",error
sys.exit( 1)
else:
data = c.fetchall()

print "record:" + str( len(data) )

for entry in data:

status = int(entry[9])
userno = int(entry[3])

e.execute("delete from ESM_WapUser Where UserNo = " + str( entry[3] ))

if status == 4: #删除
continue
# if status == 2: #冻结
# continue
# if status == 3: #开通试用
# continue;

# pprint.pprint(entry)
text = ' Values( '
text = text +"'"+ str( entry[0]) + "',"
text = text +"'"+ str( entry[1]) + "',"
text = text +"'"+ str( entry[2]) + "',"
text = text + str( entry[3] ) + ","
text = text +"'"+ str( entry[4]) + "',"
text = text +"'"+ str( entry[5]) + "',"
text = text +"'"+ str( entry[6]) + "',"
text = text +"password('"+ str( entry[7]) + "'),"
text = text + str( entry[8]) + ","
text = text + str( entry[9]) + ","
text = text +"'"+ str( entry[10]) + "',"
text = text +"'"+ str( entry[11]) + "',"
text = text +"'"+ str( entry[12]) + "',"
text = text +"'"+ str( entry[13]) + "',"
text = text +"'"+ str( entry[14]) + "',"
text = text +"'"+ str( entry[15])
text = text + "')"

isql = '''insert into ESM_WapUser(CorpId, UserId ,ParentId , UserNo ,UserName, FullName,RegPhone,Passwd ,NodeType ,Status ,AreaCode ,TelePhone ,Fax,EMail,CreateTime,ModifyTime) '''
print "-->"+isql+text
try:
e.execute(isql+text)
except MySqlDb.OperationalError,error:
print "Error:",error
sys.exit( 1 )

e.close()
c.close()
db.close()
db2.close()

ecaol 2004-06-25