当前位置:   article > 正文

删除表记录(delete from where )_delete from where

delete from where
delete from [dbo].[userinfo] where ID=2;
    delete from [dbo].[userinfo]where ID=3 or ID=4;
    --删除多行  满足条件就删除
    delete from [dbo].[userinfo]where ID in(6,7);
    --删除多行 删除6和7
    • 1
    • 2
    • 3
    声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/409374
    推荐阅读
    相关标签
      

    闽ICP备14008679号