擅长:python、mysql、java
<p>也许这与iSQLLite不同,但通常不能在values语句中使用where子句。尝试类似于:</p>
<pre><code>INSERT INTO someSQLtable (providername, providerlink)
SELECT 'somestring', 'http://www.someurl.com/stuff/'
FROM ( values (1) ) as T
WHERE NOT EXISTS (
SELECT * FROM someSQLtable
WHERE someSQLtable.providerlink = 'http://www.someurl.com/stuff/')
</code></pre>
<p>如果不支持(values(1))as T,那么可能有类似于oraclesdual或DB2的sysibm.sysdummy1在</p>