CODEWITHSUNDEEP
mysqltriggers
sundowatch
sundowatch

Reputation: 3093

When should i create mysql trigger?

Are triggers specifics to each mysql connection? Or is it done when i create trigger one time?

Upvotes: 0

Views: 69

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135739

A trigger is created on a table, not on a connection, and once defined it remains on the table until it is explicitly dropped. It can be defined to fire for INSERT, UPDATE and/or DELETE operations on the given table.

Upvotes: 5

Related Questions