delimiter $$
CREATE PROCEDURE TestWhile()
BEGIN
SELECT * from oa_case;
end $$
delimiter ;报如下错误your MySQL server version for the right syntax to use near 'delimiter $$
CREATE PROCEDURE TestWhile()
BEGIN
SELECT * from oa_case' at line 1
11:28:03 [END - 0 row(s), 0.000 secs] [Error Code: 1064, SQL State: 42000] 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 $$
delimiter' at line 1
CREATE PROCEDURE TestWhile()
BEGIN
SELECT * from oa_case;
end $$
delimiter ;报如下错误your MySQL server version for the right syntax to use near 'delimiter $$
CREATE PROCEDURE TestWhile()
BEGIN
SELECT * from oa_case' at line 1
11:28:03 [END - 0 row(s), 0.000 secs] [Error Code: 1064, SQL State: 42000] 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 $$
delimiter' at line 1
你可以在MYSQL自带的命令行工具测试你的代码。