python 文件导入mysql

最新推荐文章于 2024-08-15 14:00:00 发布

学生症

最新推荐文章于 2024-08-15 14:00:00 发布

阅读量2.2k

点赞数

分类专栏： Python Database

本文链接：https://blog.csdn.net/lydyangliu/article/details/12978925

版权

Database 同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

Python

6 篇文章 0 订阅

订阅专栏

本文介绍了如何在Python环境中，使用程序连接并导入数据到MySQL数据库的步骤和方法。

摘要由CSDN通过智能技术生成

环境：

win7 旗舰版 32bit

python2.7

mysql5.2

程序：

import os
import MySQLdb

rootdir = "e:/20121110"
i = 1
if __name__ == '__main__': 
    for parent, dirnames, filenames in os.walk(rootdir):    
        for dirname in dirnames:
            print "parent is:" + parent
            print "dirname is:" + dirname
        for filename in filenames:
            print "filename is:" + filename
            try:
                conn = MySQLdb.connect(host='localhost', user='root', passwd='******', db='lydtest', port=3306)
                cur = conn.cursor()
                sql = "load data infile 'e:/20121110/" + filename + "' into table taxi fields terminated by ',' enclosed by '\\'' lines terminated by '\\r\\n'";        
                cur.execute(sql)
                conn.commit();
                #count = cur.execute('select * from taxi')
                print 'the' + str(i) + 'success!'
                #print 'there has %s rows record' % count
                i = i + 1
                cur.close()
                conn.close()
            except MySQLdb.Error, e:
                print "Mysql Error %d: %s" % (e.args[0], e.args[1])
    print 'finished!'