MySQL查询删除两行相等的行
为此使用DELETE。让我们首先创建一个表-
create table DemoTable ( Name varchar(40), Score1 int , Score2 int );
使用插入命令在表中插入一些记录-
insert into DemoTable values('John',56,76); insert into DemoTable values('Chris',77,77); insert into DemoTable values('David',89,98);
使用select语句显示表中的所有记录-
select *from DemoTable;
这将产生以下输出-
+-------+--------+--------+ | Name | Score1 | Score2 | +-------+--------+--------+ | John | 56 | 76 | | Chris | 77 | 77 | | David | 89 | 98 | +-------+--------+--------+ 3 rows in set (0.00 sec)
以下是如果两列相等则删除一行的查询-
delete from DemoTable where Score1=Score2;
让我们再次检查表记录-
select *from DemoTable;
这将产生以下输出-
+-------+--------+--------+ | Name | Score1 | Score2 | +-------+--------+--------+ | John | 56 | 76 | | David | 89 | 98 | +-------+--------+--------+ 2 rows in set (0.00 sec)