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 account_id INT; SET account_id =(old.account_id + new.account_id); INSERT INTO Account VALUES (account_id, new.user_id); 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!