September 28, 2018

MySQL exposes a virtual schema called information_schema that describes every database, table, and column on the server. One of its most useful tables is TABLES, which includes a table_rows column