"Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> wrote:
>
> I'd like to kill 2 birds with one stone...
>
> I'd like to SELECT a set of records (for viewing) and in the same motion
> DELETE any that show up.
>
> Can it be done?
You can't do it with one query.
--
For technical support contracts
I'd like to kill 2 birds with one stone...
I'd like to SELECT a set of records (for viewing) and in the same motion
DELETE any that show up.
Can it be done?
Shawn Cummings
Engineering Project Manager
Global NAPs
10 Merrymount Rd
Quincy, MA 02169
Desk 617-507-5150
VoIP 617-507-3550
[EMAIL PROT
[snip]
>That will only result in deletion,I want it to be displayed
>and simultaneously deleted.more precisely the effect of following
>two commands in one
>
>SELECT from data where name='harsh';
>DELETE from data where name='harsh';
[/snip]
Write a .sql script with both queries and call it from t
At 0:42 +0530 6/29/03, harsh wrote:
> >thanks for help..:)
It sounds as though you really want something more like this:
DELETE FROM data WHERE name='harsh';
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two comman
> >thanks for help..:)
>
> It sounds as though you really want something more like this:
>
> DELETE FROM data WHERE name='harsh';
>
That will only result in deletion,I want it to be displayed
and simultaneously deleted.more precisely the effect of following
two commands in one
SELECT from data
At 21:40 +0530 6/28/03, harsh wrote:
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
It sounds as though you really wan
Hi,
I need to perform a query which deletes the selected
results from the table,
like
SELECT * from data where name='harsh' (here i want something to delete it
as well)
if its possible with single query...
thanks for help..:)
-
