创建存储过程,以下是在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
解决方案 »
- mysql增删改的问题
- Mysql数据库问题
- mysql查询问题
- mysql正则选出 符合如下条件记录的,怎么写SQL? 选出规则为如下的
- MYSQL编程问题
- MYSQL的字段完全书写格式问题,假设库为TEST 表名为ADMIN 语句可以写成select % from test.admin 如果再进一步要导出字段中的数据,假设字段有一个NAME,是写成像name.test.admin test.admin.na
- MYSQL问题
- SQL语句出错?还是其他问题! JSP+MYSQL+TOMCAT5.0
- mysql是否可以同时查询多张表
- postgresql+java的中文问题???
- 高手请进,求改写一个存储过程
- 在LINUX 下的mysql 配置??
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 ;