Skip to content
Skip to search - Accesskey = s
parentNode.org
The building blocks of a solid frontend.
Pasted
by
stored procedure
on
2007-11-01 01:18
as
SQL
Create New
http://pastebin.parentnode.org/
Links this one
http://pastebin.parentnode.org/26897
Comment
DELIMITER $$ DROP PROCEDURE IF EXISTS `photoAlbum`.`get_photos`$$ CREATE PROCEDURE `photoAlbum`.`get_photos` (IN n_category_id INT(1)) LANGUAGE SQL DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'Get all rows from photo' BEGIN IF n_category_id = 0 THEN SELECT * FROM photo GROUP BY date DESC; ELSE SELECT * FROM photo WHERE category_id = n_category_id GROUP BY date DESC; END IF END$$ DELIMITER ;