mssql delete用法错误？会的兄弟帮看一下

9streets

DELETE FROM Pub_ShopData WHERE ID IN 10935,10905,10851;
报错：
A Database Error Occurred
Error Number:

第 1 行: '10935' 附近有语法错误。

DELETE FROM Pub_ShopData WHERE ID IN 10935,10905,10851
我刚查了手册

IN 操作符
IN 操作符允许我们在 WHERE 子句中规定多个值。

SQL IN 语法
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)
。。。。。
应该没有错才对啊。。。但是系统就是报错。。。。

9streets

再补充一下我的sql
$where=implode(",",$_POST['ChkKindId']);
$query = $DB1->query(DELETE FROM Pub_ShopData WHERE ID IN $where");

Hex

SQL复制代码

DELETE FROM Pub_ShopData WHERE ID IN 10935,10905,10851;

复制代码

改成

SQL复制代码

DELETE FROM Pub_ShopData WHERE ID IN (10935,10905,10851);

复制代码

9streets

OK。。谢楼主。。。