Re: [PHP-DB] Insert select does not insert all rows.

the statement is executed directly on the server without php just mysql any other ideas? thanx, Andy insert into geodata_backup.provinces_test (country_code,province,province_id) select country_code, name, province_id from import.provinces_update_imported Olinux [EMAIL PROTECTED] schrieb

Re: [PHP-DB] Insert select does not insert all rows.

I'm curious, if this is not using php, why are you posting to the php-db mailing list? Why not post to the mysql mailing list? Just a thought. andy [EMAIL PROTECTED] said: the statement is executed directly on the server without php just mysql any other ideas? thanx, Andy insert

[PHP-DB] Insert select does not insert all rows.

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

Re: [PHP-DB] Insert select does not insert all rows.

The script is probably timimg out. Default timeout is 30 seconds. Stick this in your script set_time_limit(0); set_time_limit() has no effect when PHP is running in safe mode http://www.php.net/manual/en/function.set-time-limit.php olinux --- andy [EMAIL PROTECTED] wrote: Hi there, I am