How to count rows in a table ?

mysql-tutorials

How to count rows in a table ?

SELECT
TABLE_NAME,
TABLE_ROWS
FROM
`information_schema`.`tables`
WHERE
`table_schema` = ‘YOUR_DB_NAME’;

Related posts

Leave a Comment