mysql 储存过程的一些问题
时间:2016-06-12 21:50 来源:linux.it.net.cn 作者:IT
DELIMITER //
drop procedure if exists queryMonthData;
create procedure queryMonthData(IN time varchar(20))
begin
select * from bsmu_powerandconfig_info where SaveTime like concat(time, '%') order by SaveTime desc limit 1;
select * from bsmu_powerandconfig_info where SaveTime like concat(time, '%') order by SaveTime asc limit 1;
end //
DELIMITER ;
用concat解决问题
(责任编辑：IT)
| DELIMITER // drop procedure if exists queryMonthData; create procedure queryMonthData(IN time varchar(20)) begin select * from bsmu_powerandconfig_info where SaveTime like concat(time, '%') order by SaveTime desc limit 1; select * from bsmu_powerandconfig_info where SaveTime like concat(time, '%') order by SaveTime asc limit 1; end // DELIMITER ; 用concat解决问题 (责任编辑：IT) |