How do I make a counting Record in MySQL?
If you need to count the numbers of rows in MySQL, you would simply use COUNT(*). Take a look at the official documentation here.
COUNT(*)
The query would look like this.
SELECT COUNT(*) FROM your_table;