CREATE TRIGGER tr_djmh_rescount_add

AFTER INSERT ON t_resource_infoFOR EACH ROWBEGIN  if new.group_id != '2' THEN   set @serverIp = (select `value` from t_sys_config where id=1);   set @n =(SELECT redis_connect(@serverIp,6379));   set @str = (select redis_incr(CONCAT('djmh_rescount_',new.group_id)));  end if;END;