触发器实现增量备份

create TRIGGER tri_substratejob after insert
on synapse.ue_substratejob_job
for each row
begin
IF new.CREATION_TIME<DATE(NOW()) THEN
insert into ue_substratejob_job_bak values(new.ID,new.CREATION_TIME,new.CUSTOMTYPE,
new.HR_UID,new.LAST_UPDATE_TIME,new.USER_ID,new.mainID,new.USER_ENTITY_TYPE,
new.CONTAINER_ID,new.DESTINATION_SLOT,new.DESTINATION_STATION,new.DESTINATION_STATION_ID,
new.EXECUTION_ORDER,new.JOB_ID,new.LOAD_TO_SCRAP_CONT,new.RATIONALE,new.SOURCE_SLOT,
new.SOURCE_STATION,new.SOURCE_STATION_ID,new.STATEMACHINE_ID,new.SUBSTRATE_COUNT,new.SUBSTRATE_ID,
new.SUBSTRATE_JOB_TYPE,new.SUBSTRATE_NAME,new.SUBSTRATE_ROBOT_ID,new.CONTAINER_NAME,new.DESTINATION_STATION_NAME,
new.SOURCE_STATION_NAME,new.SUBSTRATE_ROBOT_NAME);
enf if;
end;
##脚本：
mysqldump -uroot -p123456 --skip-triggers -t bbs ue_substratejob_job >e:\\test\1.sql
mysql -uroot -p bbs -e "truncate table ue_substratejob_job"
mysql -uroot -p123456 bbs <e:\\test\1.sql


CREATE TABLE `ue_substratejob_job` (
`ID` bigint(20) NOT NULL,
`CREATION_TIME` datetime(0) NULL DEFAULT NULL,
`CUSTOMTYPE` int(11) NOT NULL,
`HR_UID` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`LAST_UPDATE_TIME` datetime(0) NULL DEFAULT NULL,
`USER_ID` bigint(20) NULL DEFAULT NULL,
`mainID` bigint(20) NULL DEFAULT NULL,
`USER_ENTITY_TYPE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CONTAINER_ID` bigint(20) NULL DEFAULT NULL,
`DESTINATION_SLOT` tinyint(4) NULL DEFAULT NULL,
`DESTINATION_STATION` smallint(6) NULL DEFAULT NULL,
`DESTINATION_STATION_ID` bigint(20) NULL DEFAULT NULL,
`EXECUTION_ORDER` tinyint(4) NULL DEFAULT NULL,
`JOB_ID` int(11) NULL DEFAULT NULL,
`LOAD_TO_SCRAP_CONT` tinyint(1) NULL DEFAULT NULL,
`RATIONALE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SOURCE_SLOT` tinyint(4) NULL DEFAULT NULL,
`SOURCE_STATION` smallint(6) NULL DEFAULT NULL,
`SOURCE_STATION_ID` bigint(20) NULL DEFAULT NULL,
`STATEMACHINE_ID` bigint(20) NULL DEFAULT NULL,
`SUBSTRATE_COUNT` int(11) NULL DEFAULT NULL,
`SUBSTRATE_ID` bigint(20) NULL DEFAULT NULL,
`SUBSTRATE_JOB_TYPE` int(11) NULL DEFAULT NULL,
`SUBSTRATE_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SUBSTRATE_ROBOT_ID` bigint(20) NULL DEFAULT NULL,
`CONTAINER_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DESTINATION_STATION_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SOURCE_STATION_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SUBSTRATE_ROBOT_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,