Question: What's wrong with the logic applied to this trigger?DELIMITER $$CREATE TRIGGER CreateAccount AFTER INSERT ON UserFOR EACH ROW BEGIN DECLARE account _ id INT; SET
What's wrong with the logic applied to this trigger?DELIMITER $$CREATE TRIGGER CreateAccount AFTER INSERT ON UserFOR EACH ROW BEGIN DECLARE accountid INT; SET accountid oldaccountid new.accountid; INSERT INTO Account VALUES accountid new.userid; ENDDELIMITER ;Select one:a We cannot create create accounts using Triggers.b Nothing is wrongc. User attributes are out of the scope of the triggerd. Account's attributes are out of the scope of the trigger
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
