delimiter //
drop procedure if exists sp_test//
create procedure sp_test(in curpage int,out atilte varchar(255),
out artist_name1 varchar(255)
)begin
select artist_name ,title from jos_product limit 0,curpage;
end
//
delimiter ;
抱错:
you hava an error in your sql syntax;check the manual that corresponds to your mysql server version for the right syntax to use near 'curpage';end'at line 5如果把select artist_name ,title from jos_product limit 0,curpage;换成
select artist_name ,title from jos_product where product_id=curpage;可以建立成功!!!请大家帮忙看看
drop procedure if exists sp_test//
create procedure sp_test(in curpage int,out atilte varchar(255),
out artist_name1 varchar(255)
)begin
select artist_name ,title from jos_product limit 0,curpage;
end
//
delimiter ;
抱错:
you hava an error in your sql syntax;check the manual that corresponds to your mysql server version for the right syntax to use near 'curpage';end'at line 5如果把select artist_name ,title from jos_product limit 0,curpage;换成
select artist_name ,title from jos_product where product_id=curpage;可以建立成功!!!请大家帮忙看看
BEGIN
set @stmt = 'select artist_name ,title from jos_product limit 0,?;';
prepare sq from @stmt;
set @i = curpage;
execute s1 using @i;
deallocate prepare s1;
END$$DELIMITER ;