#使用python读取文件并存入数据库中。
#!/usr/local/bin/python
import os,MySQLdb
conn=MySQLdb.Connection('localhost','username','yourpasswd','test');
cur=conn.cursor();
cur.execute("drop table if exists new");
cur.execute("drop table if exists train");
cur.execute("create table new(id1 int(3) not null,id2 int(8),id3 int(50),primary key(id1,id2,id3))");
cur.execute("rename table new to train");
#cur.execute("alter table train add id4 datetime not null after");
targetLine="";
file=open('test.txt','r');
LineNo=0;
mLine=file.readline();
while 1:
mLine=file.readline();
if mLine=='/n' or mLine == '':
break;
parts=mLine.split(' ');
numbers=[int(P) for P in parts];
cur.execute("insert into txt (id1,id2,id3) values (%d,%d,%d)" % ( numbers[0],numbers[1],numbers[2]));
cur.execute("select * from txt where id1=96");
alldata=cur.fetchall();
# print mLine;
print numbers;
# print LineNo;
#if(linecount==LineNo): targetLine=mLine;
#http://www.linuxidc.com/Linux/2007-12/9644.htm
#http://wenku.baidu.com/view/c375c000bed5b9f3f90f1c6a.html
#http://www.techweb.com.cn/news/2009-07-10/416053.shtml