Mysql – How loop through the rows for unique users and record the number of matches in another SQL table?
I recently started to study SQL and I'm trying to solve the problem: I have a voting table db.votes, it records the nickname, time and type. Like an event log. It now has 500,000 lines. I need to record the…