Re: copying tables
| From: | Chris Shiflett | Date: | Wed, 20 Nov 2002 19:02:50 +0000 |
| Subject: | Re: copying tables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-125299@lists.php.net to get a copy of this message | ||
--- Steve Buehler <steve@vespro.com> 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, indeces, etc., but it
might suffice for what you are trying to do.
Chris