Trước học MSSQL 2000 cũng procedure ầm ầm rồi. Thường thôi!

#PROCEDURE – CURSOR
CREATE DATABASE IF NOT EXISTS test;

USE test;

CREATE TABLE IF NOT EXISTS book(id INT AUTO_INCREMENT, title VARCHAR(255), PRIMARY KEY (id));
INSERT INTO book SET title='World in the war1';
INSERT INTO book SET title='World in the war2';

DELIMITER $$
DROP PROCEDURE IF EXISTS CursorProc$$
CREATE PROCEDURE CursorProc()
BEGIN

DECLARE d INT DEFAULT 0;
DECLARE _id INT;
DECLARE _title VARCHAR(255);
declare _count int default 0;

DECLARE cur CURSOR FOR
    SELECT id, title FROM book;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET d = 1;

OPEN cur;
lbl: LOOP
    FETCH cur INTO _id, _title;
    IF d=1 THEN
        LEAVE lbl;
    END IF;

    IF NOT d = 1 THEN
        SET _count = _count + 1;
    END IF;
END LOOP lbl;
CLOSE cur;

SELECT _count as `Tong so ban ghi`;

END$$
DELIMITER ;
CALL CursorProc;