Câu hỏi phỏng vấn MySQL
Câu hỏi

How many tables can a trigger associate to in...

Câu trả lời

In MySQL, a trigger is associated with exactly one table. It cannot be associated with multiple tables. Therefore, a trigger must be defined for each table where you want similar actions to be taken in response to events like INSERT, UPDATE, or DELETE[1][3][4][5].

Regarding the association of triggers with views, MySQL does not allow triggers to be directly associated with views. Triggers can only be associated with base tables. However, operations performed on updatable views that modify the underlying base tables can indirectly activate triggers associated with those base tables[1][3].

Citations:
[1] https://www.percona.com/blog/triggers-and-updatable-views/
[2] https://www.dbvis.com/thetable/sql-triggers-what-they-are-an...

expert

expert

Gợi ý câu hỏi phỏng vấn

senior

What is autocommit in MySQL? Can you run a transaction without disabling autocommit?

junior

Explain DEFAULT constraint in MySQL

junior

What is a VIEW in MySQL. How can you create and query a view?

Bình luận

Chưa có bình luận nào

Chưa có bình luận nào