Update one table to another

scottieo321 posted 4 years ago in General
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 posted 4 years ago
You just need such a query:
INSERT INTO survivor (col1, col3, col4, col5, col8)
SELECT col7, col2, col9, col6, col1 FROM character_data
kalvaro posted 4 years ago
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.