All IF-statement returns "Syntax error"

I used to have no problems using IF-statement in SQL-queries. Now nothing works, it always returns "Syntax error". This query also returns an error.

What is wrong? I know it doesn't do anything, but why do I get syntax error?

re: All IF-statement returns "Syntax error"

Heya, luttkens. Welcome to TSDN!

Try this instead:
You can only use IF ... END IF blocks in stored procedures.
http://dev.mysql.com/doc/refman/5.0/...statement.html

P.S., Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

re: All IF-statement returns "Syntax error"

Thanks!

What if i want to do something like this:

re: All IF-statement returns "Syntax error"

I thought pb just explained that to you. Are you looking for the if function instead?

re: All IF-statement returns "Syntax error"

I don't think so. I tried the code like this:

and it still doesn't work. I reckon his code only works if you want to return a string, like you do with the SELECT statement.

What I want to do is checking if a name in a table exists. If false, I want to create a new row and return the ID for the row. If true I just want to return the ID of that existing row.

In SQL-server it works fine just writing like a did in my previous post.

re: All IF-statement returns "Syntax error"

Heya, luttkens.

Try this instead:

re: All IF-statement returns "Syntax error"

Thanks for helping me! Problem solved!

re: All IF-statement returns "Syntax error"

Heya, luttkens.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)