Member Avatar for welbyobeng

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

  • 2 Contributors
  • 4 Replies
  • 113 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by welbyobeng

Recommended Answers

All 4 Replies

Member Avatar for welbyobeng

Checkout MySQL Manual.

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

Member Avatar for mwasif

What you have made so far?

Member Avatar for welbyobeng

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.