mysql_check_exists_table.sql

CREATE DEFINER=`root`@`root` PROCEDURE `procedure_name`()
BEGIN

  IF (SELECT count(*)
    FROM information_schema.TABLES
    WHERE 
      TABLE_SCHEMA = 'DB_NAME' -- Database name
      AND TABLE_NAME = 'TABLE_NAME' AND ...) = 0 THEN
      SELECT ...; -- not exists
        ELSE
      SELECT ...; -- exists
        END IF;
END