Member Avatar for welbyobeng

Is it possible to make a column on my database that automatically copy another column on the same table string together with another url?

for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" "

so that I will get http://k5live.com/thumbs/image.jpg on "fullthumb" column

  • 2 Contributors
  • 4 Replies
  • 118 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by welbyobeng
Member Avatar for mwasif

Create a column in the table with ALTER TABLE command. Then execute the following query

UPDATE files SET 
fullthumb = CONCAT('http://k5live.com/thumbs/', thumb);
Member Avatar for welbyobeng

Create a column in the table with ALTER TABLE command. Then execute the following query

UPDATE files SET 
fullthumb = CONCAT('http://k5live.com/thumbs/', thumb);

will this code be ran all the time to always update

Member Avatar for mwasif

Or you can create a trigger to UPDATE this for you when a new record is inserted.

Member Avatar for welbyobeng

Or you can create a trigger to UPDATE this for you when a new record is inserted.

nice...so how would i create a trigger to by default store "'http://k5live.com/thumbs/" and add thumb to it.

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.