How to 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);

Checkout MySQL Manual.

I did and I am having trouble doing it...Can anyone help

What you have made so far?

What will i put in my sql command to get that?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.