创建表存储过程

1 、 利用navcati创建

BEGIN

set @tablename=CONCAT('test_' ,DATE_FORMAT(time_para,'%Y%m'));
set @CREATAB := CONCAT('CREATE TABLE IF NOT EXISTS ' ,@tablename,' LIKE chejiandb' );
PREPARE CREATAB FROM @CREATAB;
EXECUTE CREATAB;

END

参数 IN `time_para` datetime；

保存为pro

命令行调用： call pro('2015-01-01 12:00:00')；

2、利用命令行创建

delimiter //

create procedure pro1(IN time_para datetime)

begin 

set @tablename = concat('test_',DATE_FORMAT(time_para,'%Y%m'));

set  @creatab:= concat('create table if not exists ',@tablename,' like test');

prepare creatab from @creatab;

execute creatab;

end //

命令行调用： call pro1('2015-01-01 12:00:00')；