How can I create a trigger to UPDATE this for me when a new record is inserted.
I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column.
UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);
I know the general syntax of CREATE TRIGGER is :
CREATE TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW trigger_statement
but I am new at mysql...Can someone help me create trigger with the above syntax