-- 补齐离职申请交接字段;只添加缺失字段,可重复执行。 SET @target_db = DATABASE(); SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE hrm_resignation_application ADD COLUMN handover_employee_id BIGINT NULL COMMENT ''交接员工ID''', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @target_db AND table_name = 'hrm_resignation_application' AND column_name = 'handover_employee_id'); PREPARE handover_stmt FROM @ddl; EXECUTE handover_stmt; DEALLOCATE PREPARE handover_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE hrm_resignation_application ADD COLUMN handover_data_status TINYINT NOT NULL DEFAULT 0 COMMENT ''用户数据交接状态:0未开始 10进行中 20已完成''', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @target_db AND table_name = 'hrm_resignation_application' AND column_name = 'handover_data_status'); PREPARE handover_stmt FROM @ddl; EXECUTE handover_stmt; DEALLOCATE PREPARE handover_stmt;