zend-blog-3-backend

1
CREATE PROCEDURE update_comments_count(IN topicID INT UNSIGNED)
2
  BEGIN
3
    DECLARE count_comments INT DEFAULT 0;
4

5
    SELECT COUNT(`id`)
6
    INTO count_comments
7
    FROM `comments` WHERE (`post_id` = topicID) AND (`deleted` = 0);
8

9
    UPDATE `posts` SET `comments_count` = count_comments
10
    WHERE `posts`.`id` = topicID;
11

12
    SELECT count_comments;
13
  END
14