Re: select/insert/delete
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: michaeljmoore@xxxxxxxxx
- Date: Wed, 8 Jun 2011 10:13:23 +0200
I saw merge was suggested, but without mentioning that merge actually can do
deletes as well in recent versions...
I haven't tested it, but what if you merge into a view that joins you
table_a and table_b together. Then it might fulfill your 3 statements in 1
go.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Wed, Jun 8, 2011 at 1:12 AM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote:
> I think the answer to this is NO, but just to be sure,
>
> Is there a single SQL statement that can:
>
> 1) SELECT row-X from table A
> 2) INSERT row-X into table B
> 3) DELETE row-X from table A
>
> It would be nice to be able to do this without a context switch.
>
> Regards,
> Mike
>
>
>
Other related posts:
