首页 > Web开发 > 详细

discuz论坛批量插入会员程序

时间:2015-03-05 23:42:48      阅读:598      评论:0      收藏:0      [点我收藏+]
begin 
declare num int;
declare charName char(10); 
declare charEmail char(20);
set num=3; 
while num < 20 do
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论坛批量插入会员程序

原文:http://blog.csdn.net/u013047660/article/details/44088073

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!