"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
[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
