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

[心之所向-]

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这种

[过眼浮云866]

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;

[心之所向-]

但是大神 最关键的一部分你没写 上面的那个 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这种查询法 所以就是这里特别懵 大神帮帮我小女子感激不尽

[心之所向-]

引用 1 楼 qq_18379499 的回复:

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;

[过眼浮云866]

你详细描述下，你想达到的效果，及取值的逻辑，