mysql 存储过程创建table

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/