- 论坛徽章:
- 0
|
写一个过程吧,很容易的!我给你一个以前我写的例子(主体部分),你可以按照这种方式改写一个:
CREATE PROCEDURE load_data (IN p_size INT,
IN p_dsize INT,
IN p_date VARCHAR(20),
IN p_optdate CHAR(
)
LANGUAGE SQL
BEGIN
DECLARE pk2 CHAR(20);
DECLARE i int;
DECLARE j int;
DECLARE p_id int;
SET i = 0 ;
SET j = 0 ;
WHILE i < p_size DO
SET pk2 = CONCAT('A',CHAR(i));
INSERT INTO test_ordermaster_his
(djbm,
operatedate, status, customerid, departid,
salerid, paymode, sumrequantity, sumquantity,
sumamountincludetax, sumassessprofit,
sumretailamounttax, isordersucceed, ispaysucceed,
indate,updatedate
)
VALUES (pk2,
p_optdate, 1, 1001, 1001,
1001, 1001, 1000, 200,
400, 300,
100, '1', '2',
DATE(p_date),current date
);
WHILE j < p_dsize DO
set p_id = FLOOR(RAND()*100) ;
INSERT INTO test_orderdetail_his
(djbm,
productid, reqquantity, quantity, amount,
assessprofit, retailamounttax, price, producttype,
indate
)
VALUES (pk2,
p_id, 100, 100, 200,
100, 200, 100, 200,
DATE(p_date)
);
SET j = j + 1 ;
END WHILE;
SET j = 0 ;
SET i = i + 1 ;
END WHILE;
commit;
END @ |
|