mysql如果存在,mysql如果存在

我一直在盯着这一段时间.也许一些新鲜的眼睛能够指出我做错了什么..这是我的疑问：

IF (EXISTS (SELECT * FROM `admin_rule_module` WHERE `rule_set_id`='13' AND `entity_id`='2'))

begin

UPDATE `admin_rule_module`

SET `permission`='allow' WHERE `entity_id`='2'

end

else

begin

INSERT INTO `admin_rule_module` (`rule_set_id`, `entity_id`, `permission`)

VALUES ('13', '2', 'allow')

end

我收到以下错误：

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 admin_rule_module

WHERE rule_set_id=’13’ AND `enti’ at

line 1

解决方法:

试试这个…

INSERT INTO admin_rule_module VALUES (13, 2, 'allow')

ON DUPLICATE KEY UPDATE permission = 'allow', entity_id = 2;

假设你至少有一个UNIQUE KEY键(rule_set_id,entity_id).如果您想使用条件语句和多个语句来执行此操作,则必须将其放在“过程”或“功能”中.

标签：sql,mysql

来源： https://codeday.me/bug/20190903/1797587.html