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, goto
[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 the
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
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 where
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