create procedure test1()
begin
select * from users;
end;
在CMD下面就可以建立;
但是在PHPMYADMIN里面,就提示下面错误,真是郁闷:
错误
SQL 查询:
CREATE PROCEDURE test1( ) BEGIN SELECT *
FROM users;
MySQL 返回:
#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