我要评论mysql创建存储过程
drop procedure if exists getcreatetimes /*前面要写delimiter $$ 或delimiter // */ delimiter $$ create procedure `getcreatetimes`() begin select usercreatetime from users; end;
mysql 存储过程有参数输入拼接
drop procedure if exists gettest01;
delimiter $$
create procedure `gettest01`(
uname varchar(50),
upass varchar(50)
)
begin
set @sql= 'select * from users where 1=1';
if uname is not null then
set @sql=concat(@sql,' and username=',"'",uname,"'");
end if;
if upass is not null then
set @sql=concat(@sql,' and password=',"'",upass,"'");
end if;
prepare stmt from @sql;
execute stmt;
end;
call gettest01(null,"123");
mysql存储过程含输入参数的拼接的分页
drop procedure if exists gettest01;
delimiter $$
create procedure `gettest01`(
startpage int,/*第startpage页，从0开始算*/
pagesize int,/*每页显示的记录数*/
uname varchar(50),
upass varchar(50)
)
begin
set @sql= 'select * from users where 1=1';
if uname is not null then
set @sql=concat(@sql,' and username=',"'",uname,"'");
end if;
if upass is not null then
set @sql=concat(@sql,' and password=',"'",upass,"'");
end if;
set @sql=concat(@sql,' limit ',startpage*pagesize,",",pagesize);
prepare stmt from @sql;
execute stmt;
end;
call gettest01(4,2,null,null);
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的，请 点击进行留言回复，万千网友为您解惑！
网友评论