Howdy! Welcome to our community of more than 130.000 members devoted to web hosting. This is a great place to get special offers from web hosts and post your own requests or ads. To start posting sign up here. Cheers!
/Peo, FreeWebSpace.net
mabye i'm misunderstanding but i can't see any reason why you would want to select everything from one table, place it into another and then delete it from the first :confused4 when the table can just be renamed.
yes you can select the entire table, i think what you have would work
and your second line a delete from table with no "where" clause would basically write over the entire table, with the same structure but no data
No, see, table 2 is like an archive, all the old data goes into it. Table 1 is where only the newest data goes. So, when new info is being entered into table 1, the old stuff is going to get moved to table 2.