MySQL: Count the Number of Records and Update the Stats Field in Another Table
I wrote this before in 2 separate posts. Actually, here’s a much better idea: use a sub query. For example, you have 2 tables, Table poets – Columns: id, poet, nation Table nations – Columns: id, nation, count Basically, nations to poets has a mapping of one to many, naturally. For example, there are 1000 …
MySQL: Count the Number of Records and Update the Stats Field in Another Table Read More »