我有一个查询来检查mysql用户列表以创建新用户。
IF (SELECT EXISTS(SELECT 1 FROM `mysql`.`user` WHERE `user` = '{{ title }}')) = 0 THEN
CREATE USER '{{ title }}'@'localhost' IDENTIFIED BY '{{ password }}'
END IF;
但是我得到了这个错误:
ERROR 1064 (42000) at line 3: 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 (SELECT EXISTS(SELECT 1 FROM `mysql`.`user` WHERE `user` = 'cms_localhost')) = 0 ' at line 1
发布于 2015-05-15 16:11:56
我使用
选择EXISTS (SELECT DISTINCT user
FROM mysql
.user
WHERE user
=“is_user”)作为用户名
如果存在则返回1,如果不存在则返回0
https://stackoverflow.com/questions/13357760
复制相似问题