import MySQLdb
db = MySQLdb.connect(host='dbhost',user='user',passwd='passwd',db='db',charset='utf8')
cursor = db.cursor()
with open("E:/mysqltest.txt",'r') as f:
line = f.readline().strip()
while line:
linestr = line.split(",")
#print(linestr[0])
line = f.readline().strip()
sql="insert into ccp_mon_rm_secdata(date_time,server_ip,caps_num,dea_time,que_num,cms_num) values (%s,%s,%s,%s,%s,%s)"
row_count=cursor.execute(sql,[linestr[0],linestr[1],linestr[2],linestr[3],linestr[4],linestr[5]])
db.commit()
cursor.close()
db.close()