Question

mysql存储过程创建失败

CREATE PROCEDURE GetType()
begin
declare Type int;
if(Type=1)
begin
select top 4 * from Product where Hot='热卖' order by id desc;
end
else if(Type=2)
begin
select top 4 * from Product where Jipin='精品' order by id desc;
end
else if(Type=3)
select top 4 * from Product where Tejia='特价' order by id desc;
end
//
好像是中文乱码问题
谢谢底下二位了

Answer 1

你的存储过程好多语法错误，试试下面这个：
delimiter //
CREATE PROCEDURE GetType(IN Type int)
begin
if Type=1 then
select top 4 * from Product where Hot='热卖' order by id desc;
elseif Type=2 then
select top 4 * from Product where Jipin='精品' order by id desc;
elseif Type=3 then
select top 4 * from Product where Tejia='特价' order by id desc;
end if
end
//
delimiter ;

Answer 2

你写的是Sqlserver的语法呀，我给你写个mysql的吧：
CREATE PROCEDURE GetType(in type int)
begin
if(Type=1) then
select * from Product where Hot='热卖' order by id desc limit 4;
elseif (Type=2) then
select * from Product where Jipin='精品' order by id desc limit 4;
elseif (Type=3) then
select * from Product where Tejia='特价' order by id desc limit 4;
end if;
end;我测试通过了