DELIMITER $$

CREATE TRIGGER newsCounter
AFTER INSERT ON News
FOR EACH ROW BEGIN
 INSERT INTO NewsCount (newsItemCount) (SELECT count(*) FROM News);
END;
$$