Re: delete only 1 row

From: <gary.rempel_at_icbc.com>
Date: 2000/05/30
Message-ID: <39343EE3.F34DCAF6@icbc.com>#1/1

Make your where clause more specific to select exactly the row you want

ie WHERE my_col = 3 AND my_other_col= ?? as long as there is only one row that fits the criteria

Gary

EN wrote:

> Hi,
>
> This is a newbie question ...
>
> For example, I'm executing the SQL statement below:
>
> DELETE FROM my_table WHERE my_col = 3
>
> My understanding is that every row with "my_col = 3" will be deleted.
> What if I only want one of those rows to be deleted?
>
> Any help is greatly appreciated,
> EN
Received on Tue May 30 2000 - 00:00:00 CDT