bitscn.com
mysql格式化例子
写了个mysql格式化例子
delimiter $$
drop procedure if exists `testdb`.`test_p_gettimerange`$$
create definer=`ipd`@`%` procedure `test_p_gettimerange`(out o_timerange text)
begin
select group_concat(concat(timerange, '|', monday, '|', tuesday, '|', wednesday,
'|', thursday, '|', friday, '|', saturday, '|', sunday, '|', id) separator '@') into o_timerange
from test_time_range;
end$$
delimiter ;
bitscn.com