Begin
declare num int;
Declare Charname char (10);
Declare Charemail char (20);
Set num=3;
While Num <
Set Charname=concat (' a3545 ', num);
Set Charemail=concat (' a3545 ', num, ' @qq. com ');
INSERT into Pre_common_member values (num,charname,charemail, ' 5f591898edd5d9c4e377a45c2f7f5574 ', 0,0,0,0,1,1,0, ', 1417239460,2,0, ", 0,0,0,1,0,0,0);
INSERT into Pre_ucenter_members value (num,charname, ' 5f591898edd5d9c4e377a45c2f7f5574 ', Charemail, ' ', ' ', ' hidden ', 1417239444,0,0, ' 447c25 ', ');
INSERT INTO Pre_ucenter_memberfields VALUES (num, ");
INSERT into Pre_common_member_status value (num, ', ':: 1 ', 50620,1417241419,1417239531,0,0,0,0,0,0,0,0);
INSERT into Pre_common_member_profile value (num, ', 0,0,0,0, ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘);
INSERT into Pre_common_member_field_forum values (num,0,26, ', ', ', ', ', ', ', ');
INSERT into pre_common_member_field_home values (num, ', ', ', ', ', 0,0,0, ', ', ', ', ', ', ', ', ', ', ');
INSERT into Pre_common_member_count values (num,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
Set num=num+1;
End while;
COMMIT;
End
Discuz Forum BULK INSERT Membership Program