•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,971 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,174 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 399 | Replies: 4
 |
•
•
Join Date: Oct 2006
Posts: 60
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
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
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
•
•
Join Date: Dec 2007
Posts: 107
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
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); •
•
Join Date: Oct 2006
Posts: 60
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by 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);
will this code be ran all the time to always update
•
•
Join Date: Dec 2007
Posts: 107
Reputation:
Rep Power: 1
Solved Threads: 13
Junior Poster
Or you can create a trigger to UPDATE this for you when a new record is inserted.
•
•
Join Date: Oct 2006
Posts: 60
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by mwasif
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Other Threads in the MySQL Forum
- Previous Thread: error in connecting MySql and PHPBB help me.....
- Next Thread: I am not a developer
