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 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 im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 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 > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 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
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 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
[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 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