db/mysql

mysql trigger signal

C/H 2013. 8. 26. 08:44

IF (groupID != 0) THEN
  SET @msg = CONCAT('ID is ', groupID);
  SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = @msg;
END IF;


반응형