创建存储过程stu(),如下:
create procedure stu()
begin
select * from students
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 4, Time: 0.000000s
正确写法应该是:
create procedure stu()
begin
select * from students;
end
原因是:少加了分号
调用存储过程:
call stu();