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
>
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]> schri
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,
>
>
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 he