日期:2014-05-16 浏览次数:20788 次
-- ---------------------------- -- Table structure for `test` -- ---------------------------- DROP TABLE IF EXISTS `test`; CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ordernum` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=500001 DEFAULT CHARSET=utf8; begin set @beginnum=1; set @endnum=500001; start transaction; while @beginnum < @endnum do set @v_beginnum=LPAD(@beginnum,7,0); set @order=concat(20121105,@v_beginnum); INSERT INTO test ( ordernum ) VALUES ( @order ); set @beginnum=@beginnum+1; end while; commit; end