Centos下Python连接mysql的小例子

来源：互联网发布：汽车保养小知识知多少编辑：程序博客网时间：2024/05/29 19:41

python mysql 以及mysql-python的插件

yum install pythonyum install MySQL-serveryum install MySQL-python

例子说明：从日志文件中筛选出有效值，插入到Mysql数据库中

#!/usr/bin/pythonimport MySQLdbimport osimport sysfileHandle = open ( '/var/log/13-11-05.log' )try: conn=MySQLdb.connect(host='ipAddress',user='developer',passwd='developer',db='test',port=3306) mycursor = conn.cursor() for  line in  fileHandle.readlines():  startIPPos = line.index('(')  endIPPos = line.index(')')  ipAddr = line[startIPPos+1:endIPPos]  startUPos = line.index('#####')  endUPos = line.index('pts')  uName = line[startUPos+5:endUPos]  mycursor.execute('insert into MyRecord (name,ip,record) values(%s,%s,%s)',(ipAddr,uName,line))  conn.commit()except MySQLdb.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])mycursor.close()conn.close()fileHandle.close()

0 0