Hello.
I need to create trigger that will run after select.
I wrote this
DROP TRIGGER IF EXISTS `article_after_select`;
DELIMITER $$
CREATE
TRIGGER `article_after_select` AFTER SELECT ON `article`
FOR EACH ROW BEGIN
/*SOME ACTION HERE*/
END;
$$
DELIMITER ;
I need when article selected, update view count.
But I can’t create trigger for SELECT.