field1: abcd field2: 1111
I'd like to have:
Can you help me?
UPDATE table SET field3 = CONCAT(field1, field2)
Check out this list of string functions. This concatenation can be done automatically by adding BEFORE triggers on INSERT and UPDATE.
Within the trigger, set
NEW.field3 = CONCAT(NEW.field1, NEW.field2)
You can find out more about triggers in MySQL at: http://dev.mysql.com/doc/refman/5.0/en/triggers.html.
This was first published in March 2007