CODEWITHSUNDEEP
mysqlsqlif-statementsyntaxsyntax-error
2mac
2mac

Reputation: 1689

IF syntax error

I'm getting a syntax error while following the MySQL guide for IF syntax.

My query is:

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

Logically, this should select 'hello world', but instead I get

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

Upvotes: 7

Views: 4391

Answers (3)

Nir Levy
Nir Levy

Reputation: 12953

using if statements like this is valid only inside stored procedure or functions.

What you'd probably like to use is the if() function, and then you can use:

select IF(0=0, 'hello world','');

Upvotes: 2

geeksal
geeksal

Reputation: 5016

If statements are not supported in general SQL flow. It can only be used in functions or procedures. However you can use it in following way

use my_db;
delimiter #
create procedure xyz()
 begin
   IF 0=0 then select 'hello world';
 end if;
end#

Upvotes: 0

Dfaure
Dfaure

Reputation: 584

Your query is only valid in a stored procedure/function context. See there for reference.

Upvotes: 8

Related Questions