need help on insert select statement
| From: | andy | Date: | Thu, 11 Apr 2002 13:56:53 +0000 |
| Subject: | need help on insert select statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18431@lists.php.net to get a copy of this message | ||
Hi there,
I would like to copy data from one table to another. My code just inserts
one record. Not all 20. Why?
This is my try:
insert into parks_new (country, province, park)
select * from national_parks_us_imported
Thanx for any help
Andy