Bord
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment