ifexists(select*frominserted)andnotexists(select*fromdeleted)--添加beginselect@VIS=Vis,@Code=Code,@ATime=ATime,@Result=Result,@CSTime=CSTime,@Compressor=Compressor,@Highv...
if exists(select * from inserted) and not exists(select * from deleted)--添加beginselect @VIS = Vis, @Code = Code,@ATime = ATime,@Result = Result, @CSTime = CSTime,@Compressor = Compressor,@Highvoltage = Highvoltage,@Reess = Reess,@RightCharger = RightCharger, @LeftCharger = LeftCharger, @GGResistance = GGResistance, @NGResistance = NGResistance, @ChargingPort = ChargingPortfrom inserted;if exists(select * from T_R_ZCResult where VIS=@VIS)begin--修改update T_R_ZCResult set ZCSC_CODE = @Code,ZCSC_ATIME = @ATime,ZCSC_RESULT = @Result,ZCSC_CSTime = @CSTime,ZCSC_Compressor = @Compressor,ZCSC_Highvoltage = @Highvoltage,ZCSC_Reess = @Reess,ZCSC_RightCharger = @RightCharger, ZCSC_LeftCharger = @LeftCharger, ZCSC_GGResistance = @GGResistance, ZCSC_NGResistance = @NGResistance, ZCSC_ChargingPort = @ChargingPortwhere VIS=@VISendelsebegin--添加insert into T_R_ZCResult(VIS,ZCSC_CODE,ZCSC_ATIME,ZCSC_RESULT,ZCSC_CSTime,ZCSC_Compressor,ZCSC_Highvoltage,ZCSC_Reess,ZCSC_RightCharger,ZCSC_LeftCharger,ZCSC_GGResistance,ZCSC_NGResistance,ZCSC_ChargingPort)values(@VIS,@Code,@ATime,@Result,@CSTime,@Compressor,@Highvoltage,@Reess,@RightCharger,@LeftCharger,@GGResistance,@NGResistance,@ChargingPort)endend以上是SQL SERVER的语句 请问怎么转成MYSQL 急急 主要是那个判断语句怎么换 MYSQL 中没用select * from inserted这种 积分真的没有了 但是必定其它方式重谢 求大神给答案
展开