论坛发帖 回帖的mysql_MySQL存储过程（批量生成论坛中发帖、回帖、主题等数据）...

USE 数据库名称1;

DROP PROCEDURE IF EXISTS 数据库名称1.存储过程名称;

delimiter $$

CREATE PROCEDURE 数据库名称1.存储过程名称(in v_count bigint,in v_count2 bigint)

BEGIN

set @vCount1=v_count;

set @vCount2=v_count2;

set @i=1;

set @vintervala=10000;

set @vintervalb=10000;

while(@i<=@vCount1)

do

#随机获取一个版块ID

select fid into @vfid from tps_forum_forum where fup<>0 and `type`='forum' and `status`=1 order by rand() limit 1;

#获取pid

select ifnull(max(pid)+1,1) into @vpid from tps_forum_post;

#获取tid

select ifnull(max(tid)+1,1) into @vtid from tps_forum_post;

#获取发帖的storeid username

select m.uid,m.username into @vuida,@vusernamea from tps_common_member m where m.uid>4 and m.`status`=0 order by rand() limit 1,1;

set @vintervala=@vintervala+@i;

set @vintervalb=@vintervalb+@i*100;

set @vtitlea=concat('发帖标题',floor(1+RAND()*10000000));

set @vpostdate=unix_timestamp(DATE_FORMAT(LOCALTIME()+@vintervala,'%Y-%m-%d %H:%i:%S'));

set @vip='192.168.1.1';

set @vmessagea=concat('发帖内容',floor(1+RAND()*10000000),'\r\n');

set @vporta=floor(10000&