insert into or update with subquerys

[Andreas Terpotiz]

Hi

i have a problem with these queries. what is wrong and how can i make them functionaly.

insert into Accounting(BytesIn,sessionID) values ((select BytesIn from
Accounting where ID=2),'session1')

and

update Accounting set BytesIn=(select BytesIn from Accounting where ID=2)
where ID=1

Anyway, we need to address in the query other rows of the same table which
is, according to the error message, impossible.

[local] ERROR 1093: You can't specify target table 'accounting' for
update in FROM clause