Update one table to another
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
Please login to leave a reply, or register at first.