https://stackoverflow.com/questions/1216175/mysql-count-records-from-one-table-and-then-update-another 更新讚數先用這個 等我 trigger 想好怎麼弄再說 SQL: ```sql UPDATE `post` SET `like` = ( SELECT COUNT(*) FROM `like` WHERE `post`.`pid` = `like`.`pid`); ```