mysql - if else mysql 语法

Question

有人可以帮我解决这个语法吗？我不知道我做错了什么!

当我尝试执行此代码时:

IF EXISTS(SELECT * FROM user WHERE user_username = '$user_username') 
THEN
UPDATE user SET user_name='$name',user_profession='$profession',user_address='$address',user_avatar='$NewImageName'
ELSE 
INSERT INTO user (user_name,user_profession,user_address,user_avatar) VALUES ('$name','$profession','$address','$NewImageName';

我收到以下错误:

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 EXISTS(SELECT * FROM user WHERE user_username = '111') THEN UPDATE user SE' at line 1

我不知道这段代码有什么问题!

Answer 1

您是否尝试过在 INSERT INTO... 语句后添加 END IF ？