create temporary table if not exists temp_procurement(
id char(32) NOT NULL,
currentStep varchar(16) default NULL,
currentStepID char(32) default NULL,
currentStepTime varchar(19) default NULL,
procedureState varchar(1) default NULL
id char(32) NOT NULL,
currentStep varchar(16) default NULL,
currentStepID char(32) default NULL,
currentStepTime varchar(19) default NULL,
procedureState varchar(1) default NULL
);
truncate TABLE temp_procurement; -- 使用前先清空临时表。
#删除临时表
DROP TEMPORARY TABLE IF EXISTS temp_procurement;