柚子快报邀请码778899分享：MySQL 创建存储过程注意项

MySQL server version for the right syntax to use near 'IF'

MySQL server version for the right syntax to use near ''

MySQL server version for the right syntax to use near 'END IF'

MySQL server version for the right syntax to use near 'END'

语法没问题，但执行时报莫名其妙错误时，分隔符的问题，mysql默认的分隔符为“；”，而“FROM table_name”后是“；”，mysql默认SQL语句结束，所以出错。

解决方法：要加上 DELIMITER // .... //

DELIMITER //

CREATE PROCEDURE mes.ADD_USER_REAL_NAME()

BEGIN

IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE

table_schema = 'test'

AND table_name = 'sys_user'

AND column_name = 'REAL_NAME')

THEN

ALTER TABLE `sys_user` ADD COLUMN `REAL_NAME` VARCHAR(20) NULL COMMENT '真实姓名' AFTER `LoginName`;

END IF;

END;

柚子快报邀请码778899分享：MySQL 创建存储过程注意项

好文推荐

评论可见，请评论后查看内容，谢谢！！！评论后请刷新页面。

夸智网