#
#  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 ;