But got stuck at PRINT: for some reason i get an error that says that my message is invalid and it expects an identifier after PRINT. What am I doing wrong?
CREATE TRIGGER insert_check
AFTER INSERT
ON country
FOR EACH ROW
BEGIN
IF (country_id > 195) THEN
PRINT 'All countries already exist'
END IF
END;
New contributor
Serro is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
9