Bug #55960 Triggers: column list for UPDATE event

• Submitted: 13 Aug 2010 3:43
• Modified: 24 Aug 2010 8:57
• Reporter: Federico Razzoli (OCA)
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any
• Tags: triggers

[13 Aug 2010 3:43] Federico Razzoli

Description:
When I create a trigger before / after UPDATE, the trigger is always executed when an UPDATE statement involves my table. But sometimes I would prefer that the trigger is "triggered" only if the statement involves a certain column(s).

HSQL and SQLite support this feature:
* http://hsqldb.org/doc/2.0/guide/triggers-chapt.html#N12E7E
* http://www.sqlite.org/lang_createtrigger.html

How to repeat:
.

Suggested fix:
Something like this:
CREATE TRIGGER ... [BEFORE | AFTER] UPDATE [OF column_list]

[24 Aug 2010 8:57] Valeriy Kravchuk

Thank you for the feature request.