SELECT COUNT MySql

Another replacement for the something parameter is COUNT, which can be used in many ways. Consider following Example , it displays the number of rows in the table by passing * as a parameter, which means “all rows.” As you’d expect, the result returned is 5, as there are five publications in the table.