一條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這種

uj5u.com熱心網友回復：

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;

uj5u.com熱心網友回復：

但是大神 最關鍵的一部分你沒寫  上面的那個
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這種查詢法  所以就是這里特別懵 大神幫幫我小女子感激不盡

uj5u.com熱心網友回復：

參考 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;

uj5u.com熱心網友回復：

你詳細描述下，你想達到的效果，及取值的邏輯，

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/48400.html

標籤：MySQL

上一篇：對于Xtrabackup的測驗方案

下一篇：mysql查詢陳述句的結果能不能當成另一個表的欄位名