摘要: 第一步,mysql端建存储过程DELIMITER $$create procedure mintime()beginselect min(year(htime)) as minnian,max(year(htime)) as maxnian FROM cas_beijing_event UNIONselect min(year(htime)) as minnian,max(year(htime)) as maxnian FROM cas_hebei_event UNIONselect min(year(htime)) as minnian,max(year(htime)) as maxnian 阅读全文