replace the data in the table from other table
885434Sep 1 2011 — edited Sep 5 2011Iam creating a backup of table Order by this query:
create table orderbckup as select * from order; - this works
For the first time i have to create a orderbckup table but every month i have to replace the data in orderbckup from order table. Is there any way where i can copy the data from order and repalce the data in orderbckp - I cannot use insert as it adds the rows. Or do i need to delete the old table and create it again or can i use update. If so can anyone plz let me know