Insert select does not insert all rows.
| From: | andy | Date: | Sun, 14 Apr 2002 14:04:59 +0000 |
| Subject: | Insert select does not insert all rows. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18488@lists.php.net to get a copy of this message | ||
Hi there,
I am trying to update a table with new rows. The new rows are in another
table so thought a insert select would be the right choice.
Unfortunatelly it is only inserting about 400 rows, but the table contains
more than 700.
So I do really not know whats going on. Maybe someone could help on this.
Thanx in advance.
Andy
Statement:
insert into geodata_backup.provinces_test
(country_code,province,province_id)
select country_code, name, province_id
from import.provinces_update_imported