IF syntax error

Question

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

Dfaure · Accepted Answer · 2016-02-12 15:51:36Z

8

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

answered Feb 12, 2016 at 15:51

Dfaure

5849 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nir Levy · Accepted Answer · 2016-02-12 15:55:12Z

2

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','');

answered Feb 12, 2016 at 15:55

Nir Levy

13k3 gold badges23 silver badges41 bronze badges

Comments

geeksal · Accepted Answer · 2016-02-12 15:55:08Z

0

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#

answered Feb 12, 2016 at 15:55

geeksal

5,0163 gold badges27 silver badges49 bronze badges

2 Comments

spiderman Over a year ago

why not just use the built in IF() function?

geeksal Over a year ago

yeah it is possible but I have answered as per the context of question as I got it!

Collectives™ on Stack Overflow

IF syntax error

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related