#coding=utf-8
import os,MySQLdb,re
path = os.path.split(os.path.realpath(__file__))[0]+"/"
f = open(path+"res.txt","r")
A = f.read()
conn=MySQLdb.connect("localhost","mydata","lybuestc","mydata")
conn.autocommit(1)
cursor = conn.cursor()
arr = re.split("\s+",A)
cursor.execute("DROP TABLE IF EXISTS CODE")
sql = """CREATE TABLE CODE (
no INT primary key,
content text
)"""
cursor.execute(sql)
for i in range(len(arr)):
if i:
sql = """INSERT INTO `code` SET `no`=%s,`content`='%s'"""%(i-1,arr[i-1])
print sql
cursor.execute(sql)
cursor.close()
conn.commit()
conn.close()
结果:
MySQLdb的一些使用可以参考:http://www.jb51.net/article/57290.htm