请教SQL删除语句的问题,学习

来源：百度知道 编辑：UC知道 时间：2024/04/29 22:32:53
select * from pay_ment where cardid='1213456'显示如下

cardid pay_time pay_num
123456 2004-4-1 9:36:14 50
123456 2004-4-1 9:58:07 200

怎样能删除第二条记录pay_num是200的那个

delete from pay_ment where cardid='1213456' and pay_num=200

一行：
DELETE FROM 表名 WHERE 条件
一列：
属于修改表结构了，一般在编程中比较忌讳这个，具体方法如下：
ALTER TABLE 表名 DROP 新列名

delete pay_ment where cardid='1213456' and pay_num=200

delete from pay_ment where pay_num=200 and cardid ='1213456'

Delete from pay_ment WHERE cardid='1213456' and pay_num='200'

Delete from pay_ment WHERE cardid='1213456' and pay_num = 200