ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What is def in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

Answer & Solution
Correct Answer: Option B
This question is about understanding the parts of a MySQL trigger statement. Triggers are like special instructions that run automatically when something happens to a table. Let's break down the code:

`CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;`

- `CREATE TRIGGER`: This tells MySQL you're creating a new trigger.
- `abc`: This is the name you've given your trigger.
- `(...) (...)`: These are placeholders for the trigger conditions (when it should run) and the trigger actions (what it should do).
- `ON def`: This is the important part! This tells MySQL which table the trigger should watch. So, `def` is the table name.
- `FOR EACH ROW ghi`: This part describes what the trigger should do for each row that is affected by the trigger conditions.

Therefore, the correct answer is Option B: table name.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.