I was wondering if it was possible to create a temporary table.
I have a bunch of records to be added to the database.But before doing that i wanted to first put these records on a temporary table,same struture as the main table of course then after that copy the temp. table to the main one and drop that.
Because at any point if i want to cancel adding the records i don't want to go to main table and delete them,if you get my point.
Is it possible to do that?If so is it possible to load and edit records from the main to the temp table?