Question

mysql if条件判断语句，帮忙看一下哪里语法错了？

if (1=1) then
Insert into person_role (PERSON_ID,VACCOUNT_ID,ROLE_ID,GMT_CREATE,GMT_MODIFIED,status,acl)
values ('21525125','1251235','3',NOW(),NOW(),'ENABLE','1');
end if;
-------------------------------------------------------------------------------
Error 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
Insert into person_role (PERSON_ID,VACCOUNT_ID,ROLE_ID,GMT_CREATE' at line 1

错误提示：

Answer 1

很明显的判断条件错误，=等号是赋值运算符，==才是比较运算符使用if判断的时候，应该是if(1==1),这是很多新手容易犯错的地方

Answer 2

把if语句的括号去掉！！mysql里面是单等号，没错，别被楼上的忽悠了！

Answer 3

cbj
525