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

junior

What is an AGGREGATE function. Name few aggregate functions used in MySQL.

junior

How are VARCHAR and CHAR different. Talk about cases where you will use one over other.

junior

What is self referencing foreign key? Give an example.

Bình luận

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

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