Venkatesh
Backup table is basically a table with the same data as the the original one.
What i did was just wrote a function which copied the data from original to the backup table.
insert into backup_table (select * from original_table) - this is just to convey my idea to u.
restore ke liye ulta query 🙂
Enjoy !!
Bhushan
Venkatesh Babu wrote:
Sir,
I want to know the SQL query for backup the recent transaction of a particular Schema and restore it when needed.
Thanks,
M.venkatesh Babu
