一条SqlServer的触发器语句转换为mysql的触发器语句

Question

if exists(select * from inserted) and not exists(select * from deleted)--添加
begin
select  @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 = ChargingPort
from 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 = @ChargingPort
where VIS=@VIS
end
else
begin
--添加
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)
end
end
以上是SQL SERVER的语句 请问怎么转成MYSQL 急急 主要是那个判断语句怎么换 MYSQL 中没用select * from inserted这种

Answer 1

IF  EXISTS (select 1 from T_R_ZCResult where VIS=@VIS) THEN
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 = @ChargingPort
where VIS=@VIS;else
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);END IF;

Answer 2

但是大神 最关键的一部分你没写  上面的那个
if exists(select * from inserted) and not exists(select * from deleted)--添加
begin
select  @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 = ChargingPort
from inserted;
因为MYSQL没有inserted  deleted这种查询法  所以就是这里特别懵 大神帮帮我小女子感激不尽