利用mysql的存储过程造数据
DELIMITER $$ DROP PROCEDURE IF EXISTS `INSERT_SUBSCRIPTION` $$CREATE PROCEDURE `INSERT_SUBSCRIPTION`()
BEGIN
DECLARE iloop SMALLINT DEFAULT 0;
DECLARE iMod MEDIUMINT DEFAULT 0;
DECLARE iNum MEDIUMINT DEFAULT 0;
DECLARE sellId MEDIUMINT DEFAULT 1112123;
DECLARE packageId MEDIUMINT DEFAULT 1112144;
DECLARE strMemberID VARCHAR(40) DEFAULT 0;
DECLARE Cur_account CURSOR FOR SELECT member_id FROM account;
OPEN Cur_account;
FETCH Cur_account INTO strMemberID;
WHILE iNum
页:
[1]