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

Update one table to another

User, date Message
scottieo321 Written by scottieo321
1 year 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
ansgar Written by ansgar
1 year ago
5098 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

kalvaro Written by kalvaro
1 year ago
605 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.