Python mysql-A large number of data insertions in a table

2017-09-06 23:28:26

ImportPymysqldb= Pymysql.connect ("localhost","Root","hy1102","TESTDB", charset='UTF8') Cursor=db.cursor () List=[]with Open ("E:\\ee.txt","R") as F: forLineinchF:ls=Line.split () forIinchrange (0,len (LS)):ifLs[i] = ="NULL": Ls[i]=None list.append (LS) f.close () SQL="""INSERT INTO Shohin VALUES (%s,%s,%s,%s,%s,%s)"""Cursor.executemany (sql,list) db.commit () db.close ()

Precautions:

• charset= ' UTF8 ': must be written when there are Chinese characters
• With Excutemany (sql,list), large amounts of data can be processed at once and are highly efficient. Null in the file is currently used in a way that is manually replaced with none
• The data in a list can be either a list or a tuple
• The excutemany in SQL must be%s

Python mysql-A large number of data insertions in a table