You wish to create a trigger on the country table. It will populate two session variables based
on the row that is deleted:
@old _countryNames with the value of the Name field
@old _countryName with the value of the code field
You may assume that only one row is ever deleted at a time.
CREATE TRIGGER Country_ad
AFTER DELETE ON Country
FOR EACH ROW
SET @old _CountryName= NEW.Name,
@ old _CountryCode=NEW.Code;
What is the outcome of the CREATE TRIGGER statement?
A.
The trigger will be created successfully.
B.
An error results because the NEW keyword cannot be used in a DELETE trigger.
C.
An error results because FOR EACH ROW is invalid syntax.
D.
An error results because a BEGIN. . .END block is required.
B
B
http://dev.mysql.com/doc/refman/5.6/en/trigger-syntax.html?ff=nopfpls
“In a DELETE trigger, only OLD.col_name can be used; there is no new row.”