 |  |  |  |  |  |  |  |
IS it possible
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
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
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: 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
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enter eudora facebook form foss gartner gnu government greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
