1，首先写一条能运行成功插入sql的语句
INSERT INTO sign_guest(realname,phone,email,sign,event_id)VALUES("jack",13800101100,"jack@mail.com",1)
2，通过python批量写如文本
f =open('guest.txt',w') for i in range(1,100): str_i = str(i) realname = jack' + str_i phone = 1380090911 + i email = "" + str_i + @mail.com" sql = INSERT INTO sign_guest(realname,event_id) values ("'+realname+",'+str(phone)+,"'+email+ f.write(sql) f.write(\n) f.close()
4，按照此思路可以进行其他语句的批量执行。