太难用了, 加了一个if就完蛋
CREATE PROCEDURE `AddTopics`($fid smallint, $author char(15) character set gbk, $subject char(80) character set gbk, $message mediumtext character set gbk)
BEGIN
//—————————–下面这个IF语句是新加的
IF (select count(*) from my023bbs_threads where fid=$fid and subject=$subject)> 0 THEN
DECLARE $authorid mediumint;
SELECT uid INTO $authorid FROM my023bbs_members WHERE username = $author;
INSERT INTO my023bbs_threads (fid, subject, author, authorid, dateline, lastpost) VALUES ($fid, $subject, $author, $authorid, UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
UPDATE my023bbs_forums SET threads = threads + 1 WHERE fid = $fid;
INSERT INTO my023bbs_posts (fid, tid, subject, author, authorid, message, dateline) VALUES ($fid, last_insert_id(), $subject, $author, $authorid, $message, UNIX_TIMESTAMP());
UPDATE my023bbs_forums SET posts = posts + 1 WHERE fid = $fid;
END IF;//————–这里是匹配新加的 IF
END
加了那个IF END IF 就出错,存储过程无法保存,太不可思议了
——解决方案——————–
不是太难用，是你不会用
delimiter //
CREATE PROCEDURE `AddTopics`($fid smallint, $author char(15) character set gbk, $subject char(80) character set gbk, $message mediumtext character set gbk)
BEGIN
declare $cnt int(11);
DECLARE $authorid mediumint;
select count(*) from my023bbs_threads where fid=$fid and subject=$subject into $cnt;
IF $cnt> 0 THEN
SELECT uid INTO $authorid FROM my023bbs_members WHERE username = $author;
INSERT INTO my023bbs_threads (fid, subject, author, authorid, dateline, lastpost) VALUES ($fid, $subject, $author, $authorid, UNIX_TIMESTAMP(), UNIX_TIMESTAMP());
UPDATE my023bbs_forums SET threads = threads + 1 WHERE fid = $fid;
INSERT INTO my023bbs_posts (fid, tid, subject, author, authorid, message, dateline) VALUES ($fid, last_insert_id(), $subject, $author, $authorid, $message, UNIX_TIMESTAMP());
UPDATE my023bbs_forums SET posts = posts + 1 WHERE fid = $fid;
END IF;
END//
delimiter ;
转载请注明原文链接：太难用了, 加了一个if就完蛋解决思路
