count=100
userid=1
f=open("AAA.sql","w")
sql="""
insert into AAA (zi1, zi12, zi13, zi13, zi15)
values ('aa{0}', null, null, '456{0}', null, null'account{0}', , 'zhang{0}@sohu.com', nul3, to_timestamp('01-01-2011 14:26:07.000000', 'dd-mm-yyyy hh24:mi:ss.ff'));
commit;
"""
for i in range(count):
f.write(sql.format(userid))
userid=userid+1
f.write("commit;");
f.close()
userid=1
f=open("AAA.sql","w")
sql="""
insert into AAA (zi1, zi12, zi13, zi13, zi15)
values ('aa{0}', null, null, '456{0}', null, null'account{0}', , 'zhang{0}@sohu.com', nul3, to_timestamp('01-01-2011 14:26:07.000000', 'dd-mm-yyyy hh24:mi:ss.ff'));
commit;
"""
for i in range(count):
f.write(sql.format(userid))
userid=userid+1
f.write("commit;");
f.close()
扫一扫
319
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
