Re: 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" <olnx@yahoo.com> schrieb im Newsbeitrag news:20020414164309.79173.qmail@web11801.mail.yahoo.com... > 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 <news.letters@gmx.de> wrote: > > 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 > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/