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>