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

Reply via email to