If a user value is given, it should be a My SQL account specified as 'user_name'@'host_name' (the same format used in the GRANT statement), CURRENT_USER, or CURRENT_USER().
Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license.
In my case I only need to set test_string := 'succes' in the row which have been updated. I could just update that field when I update the row, but I prefer not.
FOR EACH ROW means "for each row updated", not for every row in the table whether updated or not! Without FOR EACH ROW, the trigger fires ONCE per update statement.
That's why it can't use the NEW and OLD values, since there may be more than one row affected by the statement.hi, FOR EACH ROW means that the trigger will exectue for each row.
My SQL Triggers We assume that you are habituated with "My SQL Stored Procedures", if not you can read our My SQL Procedures tutorial.
You can use the following statements of My SQL procedure in triggers : How to create My SQL triggers ?