MySQLdelete某个元组||、&&操作

mysql> select * from student;
+------+------+
| Id   | name |
+------+------+
|   12 | Lili |
|   34 | Jack |
|   57 | Old  |
|   26 | Rose |
|   26 | Ann  |
+------+------+
5 rows in set (0.00 sec)

# 可以看到使用&&“或操作符”
mysql> delete from student where Id=26 && name='Ann';
Query OK, 1 row affected (0.01 sec)

mysql> select * from student;
+------+------+
| Id   | name |
+------+------+
|   12 | Lili |
|   34 | Jack |
|   57 | Old  |
|   26 | Rose |
+------+------+
4 rows in set (0.00 sec)

# 可以看到使用||“或操作符”
mysql> delete from student where Id=26 || name='Old';
Query OK, 2 rows affected (0.00 sec)

mysql> select * from student;
+------+------+
| Id   | name |
+------+------+
|   12 | Lili |
|   34 | Jack |
+------+------+
2 rows in set (0.00 sec)

mysql>

 

转载于:https://www.cnblogs.com/Robotke1/archive/2013/04/28/3050152.html