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
--- 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