1、好久没有玩过数据库了
2、初次使用MySQL
所以导入该导入的数据后,一时兴起想看看自己还会不会写procedure
于是就写了4行代码
CREATE PROCEDURE selectstop ()
BEGIN
SELECT * FROM pt_stop;
END
嗯,记忆力就应该是这样的,准没错,run!
wtf!这是什么?
Query : CREATE PROCEDURE selectstop () BEGIN SELECT * FROM pt_stop
Error Code : 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 3
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------
Query : END
Error Code : 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 'END' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
---------------------------------------------------
百度创建存储过程方法,边个系错误噶?
重新输入关键字“mysql创建存储过程失败 1064”
嗖噶!
原来MySQL会自作聪明的将“;”分号当作结束符,使用之前要先定义其他结束符以替代分号,在create procedure之前加一句
DELIMITER //
CREATE PROCEDURE selectstop ()
BEGIN
SELECT * FROM pt_stop;
END
再run,妥!
真坑人呐!