IF声明在此位置无效

I have checked/compared SQL statement several times, but it is still not working. I am using WorkBench 6.3 with MySQL. It gives me an error:

我已多次检查/比较SQL语句，但它仍然无效。我正在使用WorkBench 6.3和MySQL。它给了我一个错误：

1064 syntax error: 'IF' is not a valid input at this position.

1064语法错误：'IF'在此位置不是有效输入。

IF(EXISTS(SELECT * FROM RECORDS WHERE FORMID = 200002016 AND TimeUploaded > '2016-07-17 03:13:39' AND TimeUploaded < '2016-07-17 03:13:39'))
Begin
    SELECT TimeUploaded from RECORDS
End;

1 个解决方案

#1

You cannot use IF in an SQL statement. You can only use it in a stored procedure or a function.

您不能在SQL语句中使用IF。您只能在存储过程或函数中使用它。

You can rewrite your statement like this:

您可以像这样重写您的语句：

SELECT TimeUploaded from RECORDS
WHERE FORMID = 200002016
  AND TimeUploaded > '2016-07-17 03:13:39'
  AND TimeUploaded < '2016-07-17 03:13:39'

#1