I want to create a new table in a database that is a copy of an existing table.
I exported the existing table to my local machine. I noticed that all the insert statements (of course) have the name of the old table. I am using phpMySQL to manage the tables.
The name of the old (existing) table is resv. I want to create resvt that is a copy.
How do I do that?
It is VERY IMPORTANT that the current resv not be effected in ANY way. It is a live table taking on-line reservations (thus the name) ALL the time.