Обсуждение: select & insert

How I can make an update to a register from a select query?
I have this

update table1 set r1=(select r1+1 from table1);

I don't knok how to do this, please help!

Thanks
        Mauricio Alarcon

Mauricio Alarcon <malarcon@webdepot.com.co> writes:

> How I can make an update to a register from a select query?
> I have this
>
> update table1 set r1=(select r1+1 from table1);

Try this:

update table1 set r1=(select T1.r1+1 from table1 T1);

Note that if there is more than one row in the table1, then you might
want to limit the select clause by some condition.
--
Arcady Genkin
Don't read everything you believe.