get_actors.sql

USE sakila;
DROP PROCEDURE IF EXISTS get_actors;
DELIMITER |
CREATE PROCEDURE get_actors()
BEGIN
	SELECT actor_id, first_name, last_name
		FROM actor
		ORDER BY actor_id ASC
		LIMIT 5;
END |
DELIMITER ;