摘要:
例如: 有一张表,表中有字段,id ,name ,想模糊查询出表里name 包含 "张三“或者”李四“ 的值 select name from user where ( name like '%张三%') or (name like '%李四%')这样就能把表里包含张三,李四的数据全部都取出来了... 阅读全文
摘要:
第一步,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 阅读全文