插入多条数据
delimiter;;
CREATE PROCEDURE idata ( ) BEGIN
DECLARE
i INT;
SET i = 1;
START TRANSACTION;
WHILE
( i <= 100000 ) DO
INSERT INTO apply_info_details ( aid_id, apply_id,goods_code,box_no,gos_id,num )
VALUES
( i, 120,i,i,i,i ); //i的值每次加1,我的是测试数据,对数据要求不高,只是看下条数
SET i = i + 1;
END WHILE;
COMMIT;
END;;
delimiter;
CALL idata ( );
DROP PROCEDURE idata; //执行完删除这个过程