Re: update with an external file

M. Ostertag wrote:

[...]
> All those numbers exist in the database. So I want to update the field
> migrstate='todo' for all those numbes
> in the text-file, but I don't know how :-((
>

[...]

update zeichnung a set migrstate='todo' where a.number in (select b.number from external_table b);

might help.

Regards,

Jörg Received on Wed Sep 13 2006 - 04:07:27 CDT