CREATE PROCEDURE ins()
BEGIN
SELECT * FROM `cha`;
END;
提示错误 #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
然后我用了delimiter $$
CREATE PROCEDURE ins()
BEGIN
SELECT * FROM `cha`$$
END$$
delimiter ;还有兄弟提出来这种:
delimiter $$
CREATE PROCEDURE ins()
BEGIN
SELECT * FROM `cha`;
END;$$
delimiter ;然后整个PHPMYADMIN就没反应了 刷新也是一直正在载入的样子
等半天 载入好了 CLL一下 存储过程还是不存在会不会是版本问题? 我的是5.5.8-log提前谢谢大家了!
BEGIN
SELECT * FROM `cha`;
END;
提示错误 #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
然后我用了delimiter $$
CREATE PROCEDURE ins()
BEGIN
SELECT * FROM `cha`$$
END$$
delimiter ;还有兄弟提出来这种:
delimiter $$
CREATE PROCEDURE ins()
BEGIN
SELECT * FROM `cha`;
END;$$
delimiter ;然后整个PHPMYADMIN就没反应了 刷新也是一直正在载入的样子
等半天 载入好了 CLL一下 存储过程还是不存在会不会是版本问题? 我的是5.5.8-log提前谢谢大家了!
BEGIN
SELECT * FROM `cha`;
END;
把单引号去掉