写的第一个mysql的存储过程

最新推荐文章于 2024-04-02 14:32:41 发布

Crazy_Dreamer

最新推荐文章于 2024-04-02 14:32:41 发布

阅读量1.1k

点赞数

分类专栏： MYSQL 文章标签： mysql 存储 insert blog

本文链接：https://blog.csdn.net/Crazy_Dreamer/article/details/1534947

版权

MYSQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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')