寫的第一個mysql的預存程序

 

drop procedure if exists PublicBlog //

create procedure PublicBlog(ForumsId int,NickName char(16),Subject char(80),PubDate int,Message mediumtext,UserIp char(15))
begin

declare UserId int;
declare LastTid int;
declare LastPid int;
declare Lastpost char(128);

START TRANSACTION;
  
   select uid into UserId from cdb_members where username=NickName;
   insert into cdb_threads (fid,iconid,typeid,readperm,price,author,authorid,subject,dateline,lastpost,lastposter,views,replies,displayorder,highlight,digest,rate,blog,special,attachment,subscribed,moderated,closed,itemid,supe_pushstatus) values (ForumsId,0,0,0,0,NickName,UserId,Subject,PubDate,PubDate,NickName,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

  
   select max(tid) into LastTid from cdb_threads;
   insert into cdb_mythreads (uid,tid,dateline) values (UserId,LastTid,PubDate);

   insert into cdb_posts  (fid,tid,first,author,authorid,subject,dateline,message,useip,invisible,anonymous,usesig,bbcodeoff,smileyoff) values (ForumsId,LastTid,1,NickName,UserId,Subject,PubDate,Message,UseIp,0,0,0,-1,-1);
  
  
   select max(pid) into LastPid from cdb_posts;
   insert into cdb_myposts (uid,tid,pid,position,dateline) values (UserId,LastTid,LastPid,1,PubDate);

  
   SET Lastpost = CONCAT( LastTid, '   ', Subject, '   ', PubDate, '   ', NickName );
   update cdb_forums set threads=threads+1,posts=posts+1,todayposts=todayposts+1,lastpost=Lastpost   where fid=ForumsId;

COMMIT;
end //

call PublicBlog(12,'ph','test','1111111111','message','127.0.0.1')