mysql出现1064错误

create procedure sp_add_dataserverrouting(in dataserver_id varchar(36),in mountpathpool_id varchar(36),in precedence int)
BEGIN
if exists (select * from dataserverrouting where dataserver_id = dataserver_id and mountpathpool_id = mountpathpool_id)
then if precedence = 0
then select precedence = precedence from dataserverrouting where dataserver_id = dataserver_id and mountpathpool_id = mountpathpool_id;
end if;
update dataserverrouting set attr = attr & ~2, precedence = precedence where dataserver_id = dataserver_id and mountpathpool_id = mountpathpool_id;
elseif precedence = 0
then set precedence = 1 + IFNULL((select precedence from dataserverrouting where mountpathpool_id = mountpathpool_id order by precedence desc limit 0,1), 0);
insert into dataserverrouting select newid(), mountpathpool_id, dataserver_id, precedence, 0, getUtcUnixTime(`UTC_DATE`())*1000;
end if;
END;
报错语句：
[Err] 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 '' at line 11
第11行是：end if；不懂问题在哪儿，求大神赐教

该错误一般出现在表名或者字段名设计过程中出现了mysql关键字导致的

`file1` blob binary not null mysql里面有blob binary类型么？用blob或者binary或者varbinary试试。

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息