--- select * from bi_t_supcust_info where check_out_flag ='Y' ALTER TABLE bi_t_supcust_info DISABLE TRIGGER ALL --关闭触发器 update bi_t_supcust_info set check_out_flag ='A',deduct_way ='A' where check_out_flag ='Y' ALTER TABLE bi_t_supcust_info ENABLE TRIGGER ALL --打开触发器 --- select * from bi_t_supcust_info where supcust_no='0001' --- select * from bi_t_supcust_info where supcust_no='0002'