Re: copying tables

what about dump the table then modify the sql file to create another table? "Steve Buehler" <steve@vespro.com> wrote in message news:5.1.0.14.2.20021120124405.0257c680@vespro.com... > Using PHP and MySQL. > I have looked and can't find the answer to this problem. What I am trying > to do is to copy a mysql table to a new table name in a PHP script. The > reason for this is to keep the original table the way it is and editing the > copy. Now, I know that I can go through a loop reading the old table and > putting it into the new table, but is there an easier way that would just > duplicate or copy the mysql table to a new table name? > > The reason for all of this is my script will create the original table (a > temporary table), populate it, delete what needs to be deleted out of it, > then I need a copy of that table for a subroutine that will be running > multiple times and need the same information to start off with. > > Thanks for any help > Steve > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > ow3 >