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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php