Loop all tables for something

loop-all-tables.sql

DROP PROCEDURE IF EXISTS loopTables;
DELIMITER //
CREATE PROCEDURE `loopTables` ()
BEGIN
	DECLARE curr_table VARCHAR(200);
	DECLARE cursor_tables CURSOR FOR select table_name from information_schema.tables where table_schema = (SELECT DATABASE());
    OPEN cursor_tables;
    grant_loop: LOOP
		FETCH cursor_tables INTO curr_table;
        -- do something
        IF done THEN
			LEAVE grant_loop;
		END IF;
	END LOOP;
    CLOSE cursor_tables;
END //
DELIMITER ;

CALL loopTables();