一尘不染

IF语法错误

sql

我在遵循MySQLIF语法指南时遇到语法错误。

我的查询是:

if 0=0 then select 'hello world'; end if;

从逻辑上讲,这应该选择'hello world',但是我得到了

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if (0=0) then select 'hello world'' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end if' at line 1

阅读 235

收藏
2021-03-10

共1个答案

一尘不染

您的查询仅在存储过程/函数上下文中有效。参见那里以供参考。

2021-03-10