我想在数据库可视化工具中删除这一个,但不确定我是否写了正确的语法:
我还看到idsapusertype
25 也与 idsapusertypedetails 75 和 76 相关联。我可以使用这个吗?
delete from sap_user_type_details where idsapusertypedetails = 77
或者
delete from sap_user_type_details where idsapusertype = 25
答案1
应该是,delete from sap_user_type_details where idsapusertypedetails = 77
因为idsapusertype = 25
条件与其他记录相匹配。
为了获得最佳效果,delete from sap_user_type_details where idsapusertypedetails = 77 and idsapusertype = 25