i want to copy a whole table(say xxx) and insert into another table(say yyy).i want a query which create the table(yyy) automatically and copy from the table(xxx) because at the end, i will drop that table(yyy).Help me to write the query.
i tried like this but this doesnt work
insert into...