various MySQL stored procedures

MySQL stored procedures.sql

drop procedure IF EXISTS clear_db;
DELIMITER //

CREATE PROCEDURE clear_db ()
BEGIN
  SET @tName := (SELECT  table_name from information_schema.tables where table_schema = DATABASE() ORDER BY table_name LIMIT 1);
  WHILE @tName IS NOT NULL DO
    # SELECT CONCAT("Dropping tabe: ", @tName) as msg;
    SET @s = CONCAT("DROP TABLE ", @tName);
    PREPARE dropIT FROM @s;
    EXECUTE dropIT;
    SET @tName := (SELECT  table_name from information_schema.tables where table_schema = DATABASE() ORDER BY table_name LIMIT 1);
  END WHILE;
  DEALLOCATE PREPARE dropIT;
END

//

DELIMITER ;