SQL错误 - 无法理解为什么 [英] SQL Error - Can't understand why

问题描述

INSERT INTO TABLE1 (UID, LASTUPDATE, MODULEID,ENTRYNAME,NAME1,VALUE1) VALUES (NULL, 20150615050829, 2,'EEE','test','123') WHERE NOT EXISTS (SELECT * FROM TABLE1 WHERE ENTRYNAME = 'EEE')

< br $> b $ b

我为什么会收到错误？

Why am I getting an error?

推荐答案

1。由于可能有1,323,253,342个不同的错误，请在有错误时发布错误。

2.你的语法都错了。除非你使用SELECT，否则你不能把它放在哪里。



所以要么像解决方案1所说的那样做，要么改为：

1. Since there are a possible of 1,323,253,342 different errors, please post the error when you have one.
2. Your syntax is all wrong. You can't put a where on it unless you use a SELECT.

So either do as Solution 1 says or change it to:

INSERT INTO TABLE1 (UID, LASTUPDATE, MODULEID,ENTRYNAME,NAME1,VALUE1) 
SELECT NULL, 20150615050829, 2,'EEE','test','123' 
WHERE NOT EXISTS (SELECT * FROM TABLE1 WHERE ENTRYNAME = 'EEE')

必须是一个带有IF语句的过程的一部分我会认为



如果不是EXISTS（选择blah..blah ......）

BEGIN

INSERT INTO blah ...等等。 ..

结束



可以选择



INSERT INTO table（blah1，blah2）

SELECT'value1'，'value2'

WHERE NOT EXISTS（SELECT * FROM table WHERE blah1 ='value1'）



注意上面的SELECT关键字取代了VALUES关键字

that would have to be part of a procedure with an IF statement in it I would think

IF NOT EXISTS (SELECT blah..blah...)
BEGIN
INSERT INTO blah... blah...
END

can do with a select

INSERT INTO table(blah1, blah2)
SELECT 'value1', 'value2'
WHERE NOT EXISTS (SELECT * FROM table WHERE blah1 = 'value1')

notice the SELECT keyword above replaces the VALUES keyword

这篇关于SQL错误 - 无法理解为什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！