How do i back up data from a table before deleting all data?

Question

I have to delete all records from a table. But before that i want to keep back up of all the records so that in case I could create table with same data. how do i do it? best way to do? I only know CRUD queries.

Tushar Dikshit · Answer

Well using query. Let say you have a table TBL_Info then SELECT * INTO TBL_INFO_BACKUP FROM TBL_INFO

Istudent Rana · Answer

thank you