RE: [PHP] dumping only selected records into another table
| From: | Jay Blanchard | Date: | Tue, 11 Jun 2002 12:26:57 +0000 |
| Subject: | RE: [PHP] dumping only selected records into another table | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-19742@lists.php.net to get a copy of this message | ||
[snip]
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth the ID
included?
[/snip]
RTFMySQLM
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
HTH!
Jay
"It's hip to snip!"
"Give a man a program, frustrate him for a day.
Teach a man to program, frustrate him for a lifetime."