title: How can i insert a information_schema inside a stored proceedure
body: <p>guys im quite new to stored proceedures. can anyone guide me on how to put the following simple sql query inside a stored proceedure</p>
  
  <pre><code>$tables = mysql_query("SELECT TABLE_NAME FROM information_schema.tables WHERE table_schema = 'Fogdb' AND table_name LIKE 'fdb_table_%' ");
  </code></pre>
  
  <p>i tried like below but it dint work</p>
  
  <p>DELIMITER $$</p>
  
  <pre><code>DROP PROCEDURE IF EXISTS `alter_test_1`$$
  
  CREATE DEFINER=`Fogdb`@`10.%` PROCEDURE `alter_test_1`()
  BEGIN
  
  SELECT TABLE_NAME FROM information_schema.tables WHERE table_schema = 'Fogdb' AND table_name LIKE 'fdb_table_%' 
  
  END$$
  
  DELIMITER ;
  </code></pre>