Discuss / SQL / //
Back

//

Topic source

snow永远18岁

#1 Created at ... [Delete] [Delete and Lock User]

怎么用where删除id=1，3，4，7呢？一条一条删？只能输成id=1，id=3，id=4……这样吗？

一组麻袋某

#2 Created at ... [Delete] [Delete and Lock User]

可以用 WHERE id IN (1,3,5)

Amour33378

#3 Created at ... [Delete] [Delete and Lock User]

这里根据id删除只是举例，实际会用很多特殊的条件来选取记录集，然后删除或者修改。

  • 1

Reply