USE lims_da;
DELIMITER $$
DROP PROCEDURE IF EXISTS CREATE_HK_TABLE$$
CREATE PROCEDURE CREATE_HK_TABLE(S_NAME_IN CHAR(30))
BEGIN
SET @S_NAME=S_NAME_IN;
SET @SS = CONCAT('CREATE TABLE IF NOT EXISTS ', @S_NAME, ' LIKE lims_da.hk_db;');
PREPARE STMT FROM @SS;
EXECUTE STMT;
END$$
DELIMITER ;
CALL CREATE_HK_TABLE('HK');
这儿有个说的更明白的:
http://stonexmx.blog.163.com/blog/static/1221585872009111155732715/