An explosion has struck a public health college in Nigeria's second city of Kano, in the north, killing at least eight people, police say.