MySQL 服务器不通过 phpmyAdmin 创建存储过程

Question

delimiter //
create procedure rankPagesLive()
BEGIN 
    SET @r=0;
    UPDATE pageslive SET Rank= @r:= (@r+1) ORDER BY fan_count DESC;
END //
delimeter ;

---

Error'#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 'delimiter // create procedure rankPagesLive() BEGIN SET @r=0' at line 1

---

怎么了？

Answer 1

最后一行应该是:

delimiter ;