- 论坛徽章:
- 3
|
本帖最后由 hxl 于 2014-08-28 09:35 编辑
回复 3# q1208c
i换成x也不行,到了100000行,就用科学表示发表示了,从下面看出现了重复。
又试了下,将x赋予初始值x=1,得到的结果也是出现重复的。
[mysql@node2 shell]$ awk 'NR>999999 && NR<1000015' insert_sql_seq.sql
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1e+06,'1e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班');
INSERT INTO hxl.tb_dic_class_mem(class_id, class_name) values(1.00001e+06,'1.00001e+06班'); |
|