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

Reply via email to