#
          #  requirements: MySQL 5
          #  stored procedure: sp_copy_table
          #  parameter: source_table        - source table name
          #  parameter: destination_table   - destination table name
          #  description:  create table with name destination_table with same structure as source_table and
          #                copy rows from source_table to destination_table.
          #                You can use  full table names   source database.source table   , dest database.dest table name
          #                to copy table from one database to another.
          #
          DELIMITER \\
          DROP PROCEDURE IF EXISTS `sp_copy_table`\\
          CREATE PROCEDURE sp_copy_table(IN source_table VARCHAR(100),IN destination_table VARCHAR(100))
          BEGIN
          DECLARE sql_text VARCHAR(250);
          SET @sql_text = CONCAT("CREATE TABLE ",destination_table," SELECT * FROM ",source_table);
          PREPARE sql_stm FROM @sql_text;
          EXECUTE sql_stm;
          DEALLOCATE PREPARE sql_stm;
          END\\
          DELIMITER ;