Mysql简单的存储过程怎么写

#//创建存储过程
CREATE PROCEDURE query_t_convention_policy()
BEGIN
	select 
tcp.policy_type_name,
COUNT(tcp.policy_name like "%思明%" or null) as 思明,
COUNT(tcp.policy_name like "%海沧%" or null) as 海沧,
COUNT(tcp.policy_name like "%集美%" or null) as 集美,
COUNT(tcp.policy_name like "%湖里%" or null) as 湖里,
COUNT(tcp.policy_name like "%翔安%" or null) as 翔安,
COUNT(tcp.policy_name like "%同安%" or null) as 同安
from t_convention_policy tcp where  tcp.city_name="厦门市" and tcp.`status`=0 and year(tcp.dispatch_time)=2017
and tcp.policy_name like "%思明%" 
or tcp.policy_name like "%海沧%" 
or tcp.policy_name like "%湖里%" 
or tcp.policy_name like "%集美%" 
or tcp.policy_name like "%翔安%"
or tcp.policy_name like "%同安%"
GROUP BY tcp.policy_type_name;

END;
 

 

 

call query_t_convention_policy() #//调用存储过程

drop procedure query_t_convention_policy;#//销毁这个存储过程

 

 

使用navicat !