[Python] TXT파일 내용을 MySQL DB에 입력하기
import MySQLdb
import string
m = MySQLdb.connect(host='localhost', db='my_database')
c = m.cursor()
f = open("C:\INPUT_DATA.TXT",'r')
lines = f.readlines()
for line in lines:
rr=string.split(line)
a=str(rr[0])
b=str(rr[1])
c=str(rr[2])
print rr[0],rr[1],rr[2]
c.execute("insert into project values(%s,%s,%s)") %(a,b,c)
f.close()
m.close()
import string
m = MySQLdb.connect(host='localhost', db='my_database')
c = m.cursor()
f = open("C:\INPUT_DATA.TXT",'r')
lines = f.readlines()
for line in lines:
rr=string.split(line)
a=str(rr[0])
b=str(rr[1])
c=str(rr[2])
print rr[0],rr[1],rr[2]
c.execute("insert into project values(%s,%s,%s)") %(a,b,c)
f.close()
m.close()