Said al-Shihri, described as the second-in-command of al-Qaeda in the Arabian Peninsula (AQAP), has been killed in an operation in southern Yemen, government officials say.