Goddammit, MySQL!

[Bob Schroeck]

MySQL said:

Code:

#1064 - 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 1=1 THEN
-- do nothing
END IF;' at line 1

Whatinhell's wrong with that and every other attempt at using an IF/THEN I've tried?

<sigh>  Fuller explanation for those who care:  My modified script for importing the incremental scrape looks to see if there's an existing thread record before creating one.  Only the IF statement that controls that decision, apparently by virtue of its very existence, causes a syntax error.  The script in the error message above is the entire script I'm running now as a result of trimming my problem code down to its barest bones in the process of trying to figure out how I could screw up an IF/THEN.  (And no, it's not the contents of the block.  I've had various valid lines of code in there; nothing makes a difference.

The original code, btw, is

Code:

IF @mybb_tid IS NULL THEN
 -- create new thread here
END IF;

with a line setting @mybb_tid with a select right above it.