deleting multiple rows from sql table

Question

I got a sql table, say of the form

name         age
h             1
a             2
r             3
i             4

I want to delete the 1st row and 3rd row. I want something of the form,

delete from tablename where name=h,r;

is this the correct syntax?

Emma Thapa · Accepted Answer · 2015-07-02 07:10:31Z

10

Try:

DELETE FROM tablename WHERE name IN ('h', 'r')

edited Jul 2, 2015 at 7:10

Emma Thapa

7771 gold badge7 silver badges15 bronze badges

answered Mar 12, 2013 at 5:21

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maadh · Accepted Answer · 2013-03-12 05:23:56Z

2

Try

delete from tablename where name='h' or name='r';

answered Mar 12, 2013 at 5:23

Maadh

6434 silver badges24 bronze badges

Comments

Rahul · Accepted Answer · 2013-03-12 05:43:11Z

2

You may use or operator or in condition like
delete from tablename where name='h' or name='r';

delete from tablename where name in ('h', 'r');

answered Mar 12, 2013 at 5:43

Rahul

5,6556 gold badges38 silver badges58 bronze badges

Comments

John Woo · Accepted Answer · 2013-03-12 05:23:36Z

1

You need to use conditional operator such as `OR,

DELETE FROM tablename 
WHERE  name = 'h' OR name ='r'

answered Mar 12, 2013 at 5:23

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

Ravi Y · Accepted Answer · 2013-03-12 07:13:46Z

1

You may use or operator or in condition like

delete from tablename where name='h' or name='r';

Or

delete from tablename where name in ('h', 'r');

edited Mar 12, 2013 at 7:13

Ravi Y

4,3662 gold badges31 silver badges39 bronze badges

answered Mar 12, 2013 at 6:49

subinpanicker

462 bronze badges

Collectives™ on Stack Overflow

deleting multiple rows from sql table

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related