#创建带参数的存储过程 delimiter // create procedure pro_stu_name_id(out n varchar(20),out p int) begin select name,id into n,p from student limit 1; end // delimiter call pro_stu_name_pass(@n,@p); select @n,@p; --------------------------------------------------------------------------------------- #创建不带参数的存储过程 delimiter // create procedure pro_stu() begin select * from student limit 0,2; end // delimiter call pro_stu(); ----------------------------------------------------------------------------------------