Re: MSSQL Developer trying to learn MySQL

[Peter Brawley]

IF(...) is a function; IF...THEN...END IF is a block construct, supported only in stored routines.

And RaiseError() is a MSSQL func. In MySQL read about SIGNAL, RESIGNAL, eg ...

IF NOT EXISTS( SELECT ... ) THEN
  BEGIN
    SET @s = 'some msg';
    SIGNAL SQLSTATE '45001' SET MESSAGE_TEXT = @s;
  END;
END IF;

Edited 1 time(s). Last edit at 05/26/2021 12:11PM by Peter Brawley.