MySQL触发器在插入后更新计数

I need some help with a mysql trigger. I am currently trying to tidy up some code and offload some processing to the mysql database rather than running 2 queries and joins etc...I need some help with a mysql trigger. I am cur