MySQLdb inserting MySQL using the Bulk Insert Executemany method

Python's mysqldb library can be inserted in multiple rows using the bulk operation Executemany.

For example, to insert data into the user table (USERNAME,SALT,PWD), the specific SQL statement is as follows:

' INSERT into table name VALUES (%s,%s,%s) '  # regardless of type, use%s uniformly as placeholder param = ((username1, SALT1, Pwd1), (UserName2, SALT2, Pwd2), (Username3, SALT3, PWD3))  c8># corresponding param is a tuple or listN=cursor.executemany (Sql,param)

Before using the Execute method to loop write data, table field many times, sometimes can only write a few, and the Executemany method to commit all at once, 1w data only use less than 1s, greatly improve performance.

MySQLdb inserting MySQL using the Bulk Insert Executemany method