Thursday, 8 August 2013

MySQL IF statement. Check if variable is null

MySQL IF statement. Check if variable is null

How do I achieve this in MySQL?
SET @test = NULL;
IF (@test IS NULL) THEN
SET @variable1 = 2;
INSERT INTO ...;
ELSE
SET @variable2 = 1;
UPDATE SET ....
END IF;

No comments:

Post a Comment