Re: 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 <news.letters@gmx.de> said: > 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/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --