关于数据库删除语句写法的问题

[Prince_vegeta]

cmd.CommandText = "DELETE FROM Table_Group0 WHERE 编号=(编号) " + "VALUES (" + t + ") ";

抛出“Incorrect syntax near the keyword 'VALUES'.”错误。

cmd.CommandText = " DELETE FROM Table_Group0 WHERE 编号= " + t + " ";
这么写就能正常执行。

第一句到底哪出错了呢？
谢谢大家。

[全栈极简]

[Quote=引用楼主 prince_vegeta 的回复:]
cmd.CommandText = "DELETE FROM Table_Group0 WHERE 编号=(编号) " + "VALUES (" + t + ") ";

抛出“Incorrect syntax near the keyword 'VALUES'.”错误。

cmd.CommandText = " DELETE FROM Table_Group0 WHERE 编号= " +……
[/Quote]

delete from table_name where no="+num+"
insert into table_name values(num,...)

SQL语句别拼错。

[whycom]

sql delete 语法为

DELETE FROM 表名称 WHERE 列名称 = 值

[dalmeeme]

delete语句语法为：delete from 表名称 where 条件
insert语句语法为：insert into 表名称 values(字段1值,字段2值,……)

楼主把两者搞在一起了。

[oioixiabings]

[Quote=引用 2 楼 dalmeeme 的回复:]
delete语句语法为：delete from 表名称 where 条件
insert语句语法为：insert into 表名称 values(字段1值,字段2值,……)

楼主把两者搞在一起了。
[/Quote]
正解!

[elittle]

學習le
，剛開始學好迷茫呵