python如何导入txt文件-python如何导入txt数据库？

python将TXT数据导入数据库的方法代码如下：#!/usr/bin/python

#coding=utf-8

import _mysql,sys,time

#读入数据函数

def add_data(id,name,created_time):

try:

conn=_mysql.connect('127.0.0.1','root','')

conn.query("set names utf8")

conn.query("insert into mysql.test3(%s,%s,%s) values('%s','%s','%s')"%('object_id','object_name','created',id,name,created_time))

result=conn.use_result()

conn.close()

except _mysql.Error,e:

print ("error %d:%s" % (e.args[0],e.args[1]))

sys.exit(1)

if __name__ =="__main__":

f= open("/opt/testdata/aaa.txt","r")

time1=time.time()

print time.ctime()

#读出第一行数据，作为数据表的段名