创建存储过程,以下是在sqlserver通过的存储过程,换成mysql我却不会,语法搞的浇头难额
create proc a
as
begin
declare @id varchar(10)
select top 1 @id= id from aa order by id desc if @id is null
set @id ='CS-'+'0001'+'-'+right(year(getdate()),2)
else
set @id ='CS-'+right('000'+cast (substring(@id,4,4)+1 as varchar(3)),4)+'-'+right(year(getdate()),2)
select @id
end
create proc a
as
begin
declare @id varchar(10)
select top 1 @id= id from aa order by id desc if @id is null
set @id ='CS-'+'0001'+'-'+right(year(getdate()),2)
else
set @id ='CS-'+right('000'+cast (substring(@id,4,4)+1 as varchar(3)),4)+'-'+right(year(getdate()),2)
select @id
end
delimiter //
create procedure get_page(ppage int,psize int)
beginset @ppage=ppage;
set @psize=psize;
set @pbegin=(@ppage-1)*psize ;
set @str='select * from money order by paytime limit ?,?';
prepare smt from @str;
execute smt using @pbegin,@psize;
end
//
delimiter ;