distal-attribute
distal-attribute
distal-attribute
distal-attribute

Update one table to another

User, date Message
Written by scottieo321
11 months ago
Category: General
2 posts since Sun, 28 Jul 13
Hi guys im hoping someone can help me out here. i need to be able to copy one tables data to another tables data in the same database but i dont need all of the columns only a selected few. The things im needed updating is from character_data table to survivor table and i need to copy columns 1,3,4,5,8 for instance how would i go about doing this? i have searched on google but cant seem to find the thing i need and also if its possible would i be able to get it to automatically update every so many seconds? Thanks for any advice in advance
Written by ansgar
11 months ago
4940 posts since Fri, 07 Apr 06
You just need such a query:

INSERT INTO survivor (col1, col3, col4, col5, col8)
SELECT col7, col2, col9, col6, col1 FROM character_data

Written by kalvaro
11 months ago
588 posts since Thu, 29 Nov 07
As Ansgar suggests, simpy use SQL. You won't find a GUI tool for every fine-grained data manipulation you can ever need.
 

Please login to leave a reply, or register at first.