Re: Insert select does not insert all rows.
| From: | olinux | Date: | Sun, 14 Apr 2002 16:43:09 +0000 |
| Subject: | Re: Insert select does not insert all rows. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18492@lists.php.net to get a copy of this message | ||
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/