I have a table and back-up of same table. After taking back-up inserted some data in the main table. Now I want to delete data from main table. How to achieve it.
Let say table is 'BookMap' with column AuthorID, BookName, BookID. Took backup of 'BookMap' table and inserted new data. Now want to delete this data.
NOTE: I dont have promary key here.
If you want
BookMap to look just like the
backup_BookMap, then you might consider:
truncate table bookmap; insert into bookmap( . . .) select . . . from backup_bookmap;