# 生成insert 语句,并写入文件中
def create_sql():
for i in range(1, 1000010):
sql = 'insert into dc_test values ({}, \'{}\');'.format(i, str(i) + " dc 100w 数据测试, check dc data")
with open("test_sql.sql", "a", encoding="utf-8") as test_dc:
test_dc.writelines(sql + "\n")
if __name__ == '__main__':
create_sql()
批量生成SQL语句(生成insert 语句,并写入文件中)
最新推荐文章于 2024-04-23 15:49:27 发布