CODEWITHSUNDEEP
mysqltriggers
Solarwin
Solarwin

Reputation: 31

Mysql triggers with multiple values

How can i do the same with username value in one trigger?

Thanks

DELIMITER //
  CREATE TRIGGER notnullnameandsurname BEFORE INSERT ON guests FOR EACH ROW
  BEGIN
  IF new.name = "" then
  SIGNAL SQLSTATE '45000';
  END IF;
  END //

Upvotes: 0

Views: 25

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271151

How about using or?

DELIMITER //
  CREATE TRIGGER notnullnameandsurname BEFORE INSERT ON guests FOR EACH ROW
  BEGIN
  IF new.name = '' or new.username = '' then
  SIGNAL SQLSTATE '45000';
  END IF;
  END //

Upvotes: 1

Related Questions