Deleting a row in sql

Question

How can I delete a row in an sql table without previously knowing if it exist in that table or no

 delete from table id=4

for example I want to delete an id equal to 4 but I don't know if the id having the number 4 exist or no in this table should I use a procedure to check if it exist or can I just use a simple delete statement

score 1 · Answer 1 · answered Nov 09 '12 at 11:50

1

DELETE FROM tableName WHERE id=4;

answered Nov 09 '12 at 11:50

Vucko

20,555
10
56
107

score 1 · Accepted Answer · answered Nov 09 '12 at 11:52

1

Yes, you can use a simple delete statement to try to delete the record.

If the record exists in the table, it will be deleted. If it does not exist, then nothing will happen.

delete 
from yourTable
where id=4

answered Nov 09 '12 at 11:52

Taryn

242,637
56
362
405

than no exception would be given ? – Sora Nov 09 '12 at 12:02
no, exception will be given, see this demo on SQL Fiddle -- http://sqlfiddle.com/#!3/227f5/1 – Taryn Nov 09 '12 at 12:04

score 0 · Answer 3 · edited May 23 '17 at 12:04

0

Just do it. The syntax is like this:

DELETE FROM tableName WHERE id=4;

The number of rows deleted will be stored in @@ROWCOUNT. You will not get an exception if no rows are deleted, but @@ROWCOUNT will be 0.

You can find an example here. The example is an UPDATE statement, but DELETE works the same way.

edited May 23 '17 at 12:04

Community

1
1

answered Nov 09 '12 at 11:55

Klas Lindbäck

33,105
5
57
82

score 0 · Answer 4 · answered Feb 25 '14 at 07:02

0

do like this: DELETE FROM tableName WHERE id=4;

if there is a row exist which id= 4 than it will delete otherwise nothing will happen

answered Feb 25 '14 at 07:02

Vaimin

7
1
6

Deleting a row in sql

4 Answers4