mysql 存储过程执行ddl_mysql存储过程执行ddl语句

CREATE PROCEDURE parameter_split(in table_name VARCHAR(30),in start_time BIGINT(16),in end_time BIGINT(16))BEGIN

--得到时间

DECLARE table_year VARCHAR(5);DECLARE table_month VARCHAR(3);DECLARE table_day VARCHAR(3);--按开始时间设置年月日，并补齐单月为 05

SET table_year = YEAR(FROM_UNIXTIME(start_time/1000));SET table_month = MONTH(FROM_UNIXTIME(start_time/1000));SET table_day = DAY(FROM_UNIXTIME(start_time/1000));IF table_month < 10 THEN

SET table_month = CONCAT("0",table_month);SELECTtable_month;END IF;IF table_day < 10 THEN

SET table_day = CONCAT("0",table_day);SELECTtable_day;END IF;--设置表名

SET table_name =CONCAT(table_name,table_year,table_month,table_day);--创建表语句

IF table_name="t_sg_electric_meter_parameter_data" THEN

SET @creat_parameter_table_sql = CONCAT("CREATE TABLE IF NOT EXISTS",table_name,

" (`