“如果不存在” SQL语句出现错误 [英] "if not exists" SQL Statement Giving Error

问题描述

我正在运行以下sql查询，它给我错误1064，语法错误。

I have the following sql query running and it is giving me error 1064, syntax error.

IF NOT EXISTS (select * from locations where STREET_ADDRESS = 'test') 
BEGIN
    insert into locations (STREET_ADDRESS) values ('test') 
end;

有人可以帮帮我吗？看起来很简单，但无法运行。谢谢。

Can someone please help me out? It seems so simple yet it will not run. Thanks.

此外，我正在运行MySQL版本5.6.11

Also, I'm running MySQL version 5.6.11

推荐答案

您应使用以下类型的示例代码：

you should use this type of sample code as:

   INSERT INTO table_listnames (name, address, tele)
    SELECT * FROM (SELECT 'Rupert', 'Somewhere', '022') AS tmp
    WHERE NOT EXISTS (
        SELECT name FROM table_listnames WHERE name = 'Rupert'
    ) LIMIT 1;

单击此处

这篇关于“如果不存在” SQL语句出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！