Re: [PHP] copying tables

2002-11-20 Thread Justin French
Hi, I don't have the answer, but when that happens, the first thing I do is dig around in phpMyAdmin(.org)... it's a web based GUI for MySQL, and most of the time, when you do something (like copy a table), it shows you the query used to do it... then you just need to copy it, and integrate it int

Re: [PHP] copying tables

2002-11-20 Thread Chris Shiflett
--- Steve Buehler <[EMAIL PROTECTED]> wrote: > What I am trying to do is to copy a mysql table to a new table name > in a PHP script. An SQL statement similar to this might be what you are looking for: create table tmp_foo as select * from foo I believe this will fail to create any keys, indece