Mysql数据库头歌实训任务存储过程如何通关?

Question

这样输入是哪里有问题啊，看不懂平台给的报错。求完整答案。
具体报错如下:
ERROR 1064 (42000) at line 6: 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 'else set p_customerLevel="PLATINUM"; end if; select p_customNumber as customNumb' at line 9
ERROR 1305 (42000) at line 3: PROCEDURE mydb.GetCustomerLevel does not exist

Answer 1

题主分隔符是全角状态下的吧？改成半角状态下的$$，而不是全角的＄＄，最后的delimiter少了分隔符内容