SQL 从sql表中删除多行

Question

提问by user1915108

I got a sql table, say of the form

我有一个 sql 表，说的形式

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?

这是正确的语法吗？

Answer 1

Try:

尝试：

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

Answer 2

Try

尝试

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

Answer 3

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');

Answer 4

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');

Answer 5

You need to use conditional operator such as `OR,

您需要使用条件运算符，例如`OR，

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