 |  |  |  |  |  |  |  |
IS it possible
 |
•
•
Join Date: Oct 2006
Posts: 75
Reputation: 
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: 223
Reputation:
Solved Threads: 34
Posting Whiz in Training
Create a column in the table with ALTER TABLE command. Then execute the following query
MySQL Syntax (Toggle Plain Text)
•
•
Join Date: Oct 2006
Posts: 75
Reputation:
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
MySQL Syntax (Toggle Plain Text)
will this code be ran all the time to always update
•
•
Join Date: Dec 2007
Posts: 223
Reputation:
Solved Threads: 34
Posting Whiz in Training
Or you can create a trigger to UPDATE this for you when a new record is inserted.
•
•
Join Date: Oct 2006
Posts: 75
Reputation:
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.
|
Other Threads in the MySQL Forum
- Previous Thread: error in connecting MySql and PHPBB help me.....
- Next Thread: I am not a developer
Views: 1015 | Replies: 4
| Thread Tools | Search this Thread |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
"use" .db 1 ajax alphabet amazon aws camparingtocolumns cascade cast code convert count count(col) data database delete design distinct ec2 eliminate enter error form generator html images innerjoins insert join keyword keywords matchingcolumns multiple multipletables mysql mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch noob number open operand oracle order parse pdf php print query recursive relationaldatabases relationship relationships remove reorderingcolumns resultset retrieve script search select simpledb sort sql statement string syntax table tree type-conversion update values welsh
