Get record counts for all tables in MySQL database

Question

Is there a way to get the count of rows in all tables in a MySQL database without running a SELECT count   on each table

User · Answer

The following query produces a nother  query that will get the value of count    for every table  from every schema  listed in information schema tables   The entire result of the query shown here - all rows taken together - comprise a valid SQL statement ending in a semicolon - no dangling  union   The dangling union is avoided by use of a union in the query below   select concat  select     table schema       table name     as  schema table                             count                     from    table schema       table name    union    as  Query Row    from information schema tables  union  select   select null  null limit 0

User · Answer

I just run   show table status    This will give you the row count for EVERY table plus a bunch of other info  I used to use the selected answer above  but this is much easier   I m not sure if this works with all versions  but I m using 5 5 with InnoDB engine

User · Answer

This is how I count TABLES and ALL RECORDS using PHP    dtb   mysql query  SHOW TABLES   or die  mysql error      jmltbl   0   jml record   0   jml record   0   while   row   mysql fetch array  dtb           sql1   mysql query  SELECT   FROM      row 0                     jml record   mysql num rows  sql1                   echo  Table       row 0            jml record record     lt br gt               jmltbl         jml record     jml record     echo  -------------------------------- lt br gt  jmltbl Tables   jml record  gt  records

User · Answer

You can try this  It is working fine for me   SELECT IFNULL table schema  Total    Database  TableCount  FROM  SELECT COUNT 1  TableCount table schema        FROM information schema tables        WHERE table schema NOT IN   information schema   mysql          GROUP BY table schema WITH ROLLUP  A

User · Answer

Based on  Nathan s answer above  but without needing to  remove the final union  and with the option to sort the output  I use the following SQL   It generates another SQL statement which  then just run   select CONCAT   select   from   n   group concat  single select SEPARATOR   UNION n      n   Q order by Q exact row count desc   as sql query from       SELECT CONCAT           SELECT              table name              AS table name  COUNT 1  AS exact row count         FROM              table schema                         table name                     as single select     FROM INFORMATION SCHEMA TABLES      WHERE table schema    YOUR SCHEMA NAME        and table type    BASE TABLE    Q    You do need a sufficiently large value of group concat max len server variable but from MariaDb 10 2 4 it should default to 1M

User · Answer

This is what I do to get the actual count  no using the schema    It s slower but more accurate   It s a two step process at   Get list of tables for your db  You can get it using   mysql -uroot -p mydb -e  show tables   Create and assign the list of tables to the array variable in this bash script  separated by a single space just like in the code below   array   table1 table2 table3    for i in    array      do     echo  i     mysql -uroot mydb -e  select count    from  i  done  Run it   chmod  x script sh    script sh

User · Answer

You can try this  It is working fine for me   SELECT IFNULL table schema  Total    Database  TableCount  FROM  SELECT COUNT 1  TableCount table schema        FROM information schema tables        WHERE table schema NOT IN   information schema   mysql          GROUP BY table schema WITH ROLLUP  A

User · Answer

One more option  for non InnoDB it uses data from information schema TABLES  as it s faster   for InnoDB - select count    to get the accurate count  Also it ignores views   SET  table schema   DATABASE    -- or SET  table schema    my db name    SET GROUP CONCAT MAX LEN 131072  SET  selects   NULL   SELECT GROUP CONCAT           SELECT     table name    as TABLE NAME  COUNT    as TABLE ROWS FROM     table name              SEPARATOR   nUNION n   INTO  selects   FROM information schema TABLES   WHERE TABLE SCHEMA    table schema         AND ENGINE    InnoDB          AND TABLE TYPE    BASE TABLE    SELECT CONCAT WS   nUNION n     CONCAT  SELECT TABLE NAME  TABLE ROWS FROM information schema TABLES WHERE TABLE SCHEMA     AND ENGINE  lt  gt   InnoDB  AND TABLE TYPE    BASE TABLE        selects  INTO  selects   PREPARE stmt FROM  selects  EXECUTE stmt USING  table schema  DEALLOCATE PREPARE stmt    If your database has a lot of big InnoDB tables counting all rows can take more time

User · Answer

SELECT SUM TABLE ROWS        FROM INFORMATION SCHEMA TABLES       WHERE TABLE SCHEMA     your db      Note from the docs though  For InnoDB tables  the row count is only a rough estimate used in SQL optimization  You ll need to use COUNT    for exact counts  which is more expensive

User · Answer

Like  Venkatramanan and others I found INFORMATION SCHEMA TABLES unreliable  using InnoDB  MySQL 5 1 44   giving different row counts each time I run it even on quiesced tables  Here s a relatively hacky  but flexible adaptable  way of generating a big SQL statement you can paste into a new query  without installing Ruby gems and stuff   SELECT CONCAT       SELECT          table name          AS table name  COUNT    AS exact row count FROM          table schema                 table name          UNION      FROM INFORMATION SCHEMA TABLES  WHERE table schema      my schema       It produces output like this   SELECT  func  AS table name  COUNT    AS exact row count FROM my schema func UNION                          SELECT  general log  AS table name  COUNT    AS exact row count FROM my schema general log UNION            SELECT  help category  AS table name  COUNT    AS exact row count FROM my schema help category UNION        SELECT  help keyword  AS table name  COUNT    AS exact row count FROM my schema help keyword UNION          SELECT  help relation  AS table name  COUNT    AS exact row count FROM my schema help relation UNION        SELECT  help topic  AS table name  COUNT    AS exact row count FROM my schema help topic UNION              SELECT  host  AS table name  COUNT    AS exact row count FROM my schema host UNION                          SELECT  ndb binlog index  AS table name  COUNT    AS exact row count FROM my schema ndb binlog index UNION    Copy and paste except for the last UNION to get nice output like    ------------------ -----------------    table name         exact row count    ------------------ -----------------    func                             0     general log                      0     help category                   37     help keyword                   450     help relation                  990     help topic                     504     host                             0     ndb binlog index                 0    ------------------ -----------------  8 rows in set  0 01 sec

User · Answer

If you want the exact numbers  use the following ruby script  You need Ruby and RubyGems   Install following Gems     gt  gem install dbi   gt  gem install dbd-mysql   File  count table records rb  require  rubygems  require  dbi   db handler   DBI connect  DBI Mysql database name localhost    username    password      Collect all Tables sql 1   db handler prepare  SHOW tables    sql 1 execute tables   sql 1 map    row  row 0   sql 1 finish  tables each do  table name    sql 2   db handler prepare  SELECT count    FROM   table name       sql 2 execute   sql 2 each do  row      puts  Table   table name  has   row 0   rows     end   sql 2 finish end  db handler disconnect   Go back to the command-line     gt  ruby count table records rb   Output   Table users has 7328974 rows

User · Answer

Simple way   SELECT   TABLE NAME  SUM TABLE ROWS  FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA     Your DB   GROUP BY TABLE NAME    Result example    ---------------- -----------------    TABLE NAME       SUM TABLE ROWS     ---------------- -----------------    calls                       7533     courses                      179     course modules               298     departments                   58     faculties                    236     modules                      169     searches                   25423     sections                     532     universities                  57     users                      10293    ---------------- -----------------

User · Answer

There s a bit of a hack workaround to this estimate problem   Auto Increment - for some reason this returns a much more accurate row count for your database if you have auto increment set up on tables   Found this when exploring why show table info did not match up with the actual data   SELECT table schema  Database   SUM data length   index length  AS  DBSize   SUM TABLE ROWS  AS DBRows  SUM AUTO INCREMENT  AS DBAutoIncCount FROM information schema tables GROUP BY table schema     -------------------- ----------- --------- ----------------    Database             DBSize      DBRows    DBAutoIncCount    -------------------- ----------- --------- ----------------    Core                  35241984     76057             8341     information schema      163840      NULL             NULL     jspServ                  49152        11              856     mysql                  7069265     30023                1     net snmp              47415296     95123              324     performance schema           0   1395326             NULL     sys                      16384         6             NULL     WebCal                  655360      2809             NULL     WxObs                494256128    530533          3066752    -------------------- ----------- --------- ----------------  9 rows in set  0 40 sec    You could then easily use PHP or whatever to return the max of the 2 data columns to give the  best estimate  for row count   i e    SELECT table schema  Database   SUM data length   index length  AS  DBSize   GREATEST SUM TABLE ROWS   SUM AUTO INCREMENT   AS DBRows FROM information schema tables GROUP BY table schema    Auto Increment will always be  1    table count  rows off  but even with 4 000 tables and 3 million rows  that s 99 9  accurate  Much better than the estimated rows   The beauty of this is that the row counts returned in performance schema are erased for you  as well  because greatest does not work on nulls  This may be an issue if you have no tables with auto increment  though

User · Answer

This is how I count TABLES and ALL RECORDS using PHP    dtb   mysql query  SHOW TABLES   or die  mysql error      jmltbl   0   jml record   0   jml record   0   while   row   mysql fetch array  dtb           sql1   mysql query  SELECT   FROM      row 0                     jml record   mysql num rows  sql1                   echo  Table       row 0            jml record record     lt br gt               jmltbl         jml record     jml record     echo  -------------------------------- lt br gt  jmltbl Tables   jml record  gt  records

User · Answer

The code below generation the select query for all tales  Just delete last  UNION ALL  select all result and paste a new query window to run   SELECT  concat  select      table name      as TableName  COUNT    as RowCount from     table name     UNION ALL     as TR FROM information schema tables where  table schema    Database Name

User · Answer

One more option  for non InnoDB it uses data from information schema TABLES  as it s faster   for InnoDB - select count    to get the accurate count  Also it ignores views   SET  table schema   DATABASE    -- or SET  table schema    my db name    SET GROUP CONCAT MAX LEN 131072  SET  selects   NULL   SELECT GROUP CONCAT           SELECT     table name    as TABLE NAME  COUNT    as TABLE ROWS FROM     table name              SEPARATOR   nUNION n   INTO  selects   FROM information schema TABLES   WHERE TABLE SCHEMA    table schema         AND ENGINE    InnoDB          AND TABLE TYPE    BASE TABLE    SELECT CONCAT WS   nUNION n     CONCAT  SELECT TABLE NAME  TABLE ROWS FROM information schema TABLES WHERE TABLE SCHEMA     AND ENGINE  lt  gt   InnoDB  AND TABLE TYPE    BASE TABLE        selects  INTO  selects   PREPARE stmt FROM  selects  EXECUTE stmt USING  table schema  DEALLOCATE PREPARE stmt    If your database has a lot of big InnoDB tables counting all rows can take more time

User · Answer

You can probably put something together with Tables table   I ve never done it  but it looks like it has a column for TABLE ROWS and one for TABLE NAME     To get rows per table  you can use a query like this     SELECT table name  table rows FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA      YOUR SCHEMA

User · Answer

Simple way   SELECT   TABLE NAME  SUM TABLE ROWS  FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA     Your DB   GROUP BY TABLE NAME    Result example    ---------------- -----------------    TABLE NAME       SUM TABLE ROWS     ---------------- -----------------    calls                       7533     courses                      179     course modules               298     departments                   58     faculties                    236     modules                      169     searches                   25423     sections                     532     universities                  57     users                      10293    ---------------- -----------------

User · Answer

This stored procedure lists tables  counts records  and produces a total number of records at the end   To run it after adding this procedure   CALL  COUNT ALL RECORDS BY TABLE        -  The Procedure   DELIMITER     CREATE DEFINER  root   127 0 0 1  PROCEDURE  COUNT ALL RECORDS BY TABLE    BEGIN DECLARE done INT DEFAULT 0  DECLARE TNAME CHAR 255    DECLARE table names CURSOR for      SELECT table name FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA   DATABASE     DECLARE CONTINUE HANDLER FOR NOT FOUND SET done   1   OPEN table names      DROP TABLE IF EXISTS TCOUNTS  CREATE TEMPORARY TABLE TCOUNTS          TABLE NAME CHAR 255       RECORD COUNT INT     ENGINE   MEMORY     WHILE done   0 DO    FETCH NEXT FROM table names INTO TNAME      IF done   0 THEN     SET  SQL TXT   CONCAT  INSERT INTO TCOUNTS SELECT      TNAME       AS TABLE NAME  COUNT    AS RECORD COUNT FROM    TNAME             PREPARE stmt name FROM  SQL TXT      EXECUTE stmt name      DEALLOCATE PREPARE stmt name      END IF   END WHILE   CLOSE table names   SELECT   FROM TCOUNTS   SELECT SUM RECORD COUNT  AS TOTAL DATABASE RECORD CT FROM TCOUNTS   END

User · Answer

If you know the number of tables and their names  and assuming they each have primary keys  you can use a cross join in combination with COUNT distinct  column   to get the rows that come from each table   SELECT     COUNT distinct t1 id        COUNT distinct t2 id        COUNT distinct t3 id  AS totalRows FROM firstTable t1  secondTable t2  thirdTable t3    Here is an SQL Fiddle example

User · Answer

This stored procedure lists tables  counts records  and produces a total number of records at the end   To run it after adding this procedure   CALL  COUNT ALL RECORDS BY TABLE        -  The Procedure   DELIMITER     CREATE DEFINER  root   127 0 0 1  PROCEDURE  COUNT ALL RECORDS BY TABLE    BEGIN DECLARE done INT DEFAULT 0  DECLARE TNAME CHAR 255    DECLARE table names CURSOR for      SELECT table name FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA   DATABASE     DECLARE CONTINUE HANDLER FOR NOT FOUND SET done   1   OPEN table names      DROP TABLE IF EXISTS TCOUNTS  CREATE TEMPORARY TABLE TCOUNTS          TABLE NAME CHAR 255       RECORD COUNT INT     ENGINE   MEMORY     WHILE done   0 DO    FETCH NEXT FROM table names INTO TNAME      IF done   0 THEN     SET  SQL TXT   CONCAT  INSERT INTO TCOUNTS SELECT      TNAME       AS TABLE NAME  COUNT    AS RECORD COUNT FROM    TNAME             PREPARE stmt name FROM  SQL TXT      EXECUTE stmt name      DEALLOCATE PREPARE stmt name      END IF   END WHILE   CLOSE table names   SELECT   FROM TCOUNTS   SELECT SUM RECORD COUNT  AS TOTAL DATABASE RECORD CT FROM TCOUNTS   END

User · Answer

I just run   show table status    This will give you the row count for EVERY table plus a bunch of other info  I used to use the selected answer above  but this is much easier   I m not sure if this works with all versions  but I m using 5 5 with InnoDB engine

User · Answer

The following query produces a nother  query that will get the value of count    for every table  from every schema  listed in information schema tables   The entire result of the query shown here - all rows taken together - comprise a valid SQL statement ending in a semicolon - no dangling  union   The dangling union is avoided by use of a union in the query below   select concat  select     table schema       table name     as  schema table                             count                     from    table schema       table name    union    as  Query Row    from information schema tables  union  select   select null  null limit 0

User · Answer

The code below generation the select query for all tales  Just delete last  UNION ALL  select all result and paste a new query window to run   SELECT  concat  select      table name      as TableName  COUNT    as RowCount from     table name     UNION ALL     as TR FROM information schema tables where  table schema    Database Name

User · Answer

If you use the database information schema  you can use this mysql code  the where part makes the query not show tables that have a null value for rows    SELECT TABLE NAME  TABLE ROWS FROM  TABLES  WHERE  TABLE ROWS   gt  0

User · Answer

Poster wanted row counts without counting  but didn t specify which table engine  With InnoDB  I only know one way  which is to count   This is how I pick my potatoes     Put this function in your bash and call with    rowpicker DBUSER DBPASS DBNAME  TABLEPATTERN  function rowpicker         UN  1     PW  2     DB  3     if     -z   4     then         PAT  LIKE   4           tot -2     else         PAT            tot -1     fi     for t in  mysql -u   UN  -p  PW    DB  -e  SHOW TABLES  PAT   do         if    tot -lt 0    then             echo  Skipping  t               let  tot    1           else             c  mysql -u   UN  -p  PW    DB  -e  SELECT count    FROM  t                c  echo  c   cut -d     -f 2               echo   t   c               let  tot    c           fi      done      echo  total rows   tot      I am making no assertions about this other than that this is a really ugly but effective way to get how many rows exist in each table in the database regardless of table engine and without having to have permission to install stored procedures  and without needing to install ruby or php  Yes  its rusty  Yes it counts  count    is accurate

User · Answer

Poster wanted row counts without counting  but didn t specify which table engine  With InnoDB  I only know one way  which is to count   This is how I pick my potatoes     Put this function in your bash and call with    rowpicker DBUSER DBPASS DBNAME  TABLEPATTERN  function rowpicker         UN  1     PW  2     DB  3     if     -z   4     then         PAT  LIKE   4           tot -2     else         PAT            tot -1     fi     for t in  mysql -u   UN  -p  PW    DB  -e  SHOW TABLES  PAT   do         if    tot -lt 0    then             echo  Skipping  t               let  tot    1           else             c  mysql -u   UN  -p  PW    DB  -e  SELECT count    FROM  t                c  echo  c   cut -d     -f 2               echo   t   c               let  tot    c           fi      done      echo  total rows   tot      I am making no assertions about this other than that this is a really ugly but effective way to get how many rows exist in each table in the database regardless of table engine and without having to have permission to install stored procedures  and without needing to install ruby or php  Yes  its rusty  Yes it counts  count    is accurate

User · Answer

SELECT SUM TABLE ROWS        FROM INFORMATION SCHEMA TABLES       WHERE TABLE SCHEMA     your db      Note from the docs though  For InnoDB tables  the row count is only a rough estimate used in SQL optimization  You ll need to use COUNT    for exact counts  which is more expensive

User · Answer

Based on  Nathan s answer above  but without needing to  remove the final union  and with the option to sort the output  I use the following SQL   It generates another SQL statement which  then just run   select CONCAT   select   from   n   group concat  single select SEPARATOR   UNION n      n   Q order by Q exact row count desc   as sql query from       SELECT CONCAT           SELECT              table name              AS table name  COUNT 1  AS exact row count         FROM              table schema                         table name                     as single select     FROM INFORMATION SCHEMA TABLES      WHERE table schema    YOUR SCHEMA NAME        and table type    BASE TABLE    Q    You do need a sufficiently large value of group concat max len server variable but from MariaDb 10 2 4 it should default to 1M

User · Answer

There s a bit of a hack workaround to this estimate problem   Auto Increment - for some reason this returns a much more accurate row count for your database if you have auto increment set up on tables   Found this when exploring why show table info did not match up with the actual data   SELECT table schema  Database   SUM data length   index length  AS  DBSize   SUM TABLE ROWS  AS DBRows  SUM AUTO INCREMENT  AS DBAutoIncCount FROM information schema tables GROUP BY table schema     -------------------- ----------- --------- ----------------    Database             DBSize      DBRows    DBAutoIncCount    -------------------- ----------- --------- ----------------    Core                  35241984     76057             8341     information schema      163840      NULL             NULL     jspServ                  49152        11              856     mysql                  7069265     30023                1     net snmp              47415296     95123              324     performance schema           0   1395326             NULL     sys                      16384         6             NULL     WebCal                  655360      2809             NULL     WxObs                494256128    530533          3066752    -------------------- ----------- --------- ----------------  9 rows in set  0 40 sec    You could then easily use PHP or whatever to return the max of the 2 data columns to give the  best estimate  for row count   i e    SELECT table schema  Database   SUM data length   index length  AS  DBSize   GREATEST SUM TABLE ROWS   SUM AUTO INCREMENT   AS DBRows FROM information schema tables GROUP BY table schema    Auto Increment will always be  1    table count  rows off  but even with 4 000 tables and 3 million rows  that s 99 9  accurate  Much better than the estimated rows   The beauty of this is that the row counts returned in performance schema are erased for you  as well  because greatest does not work on nulls  This may be an issue if you have no tables with auto increment  though

User · Answer

This is what I do to get the actual count  no using the schema    It s slower but more accurate   It s a two step process at   Get list of tables for your db  You can get it using   mysql -uroot -p mydb -e  show tables   Create and assign the list of tables to the array variable in this bash script  separated by a single space just like in the code below   array   table1 table2 table3    for i in    array      do     echo  i     mysql -uroot mydb -e  select count    from  i  done  Run it   chmod  x script sh    script sh

User · Answer

SELECT SUM TABLE ROWS        FROM INFORMATION SCHEMA TABLES       WHERE TABLE SCHEMA     your db      Note from the docs though  For InnoDB tables  the row count is only a rough estimate used in SQL optimization  You ll need to use COUNT    for exact counts  which is more expensive

User · Answer

SELECT TABLE NAME SUM TABLE ROWS    FROM INFORMATION SCHEMA TABLES   WHERE TABLE SCHEMA    your db    GROUP BY TABLE NAME    That s all you need

User · Answer

You can probably put something together with Tables table   I ve never done it  but it looks like it has a column for TABLE ROWS and one for TABLE NAME     To get rows per table  you can use a query like this     SELECT table name  table rows FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA      YOUR SCHEMA

User · Answer

You can probably put something together with Tables table   I ve never done it  but it looks like it has a column for TABLE ROWS and one for TABLE NAME     To get rows per table  you can use a query like this     SELECT table name  table rows FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA      YOUR SCHEMA

User · Answer

If you want the exact numbers  use the following ruby script  You need Ruby and RubyGems   Install following Gems     gt  gem install dbi   gt  gem install dbd-mysql   File  count table records rb  require  rubygems  require  dbi   db handler   DBI connect  DBI Mysql database name localhost    username    password      Collect all Tables sql 1   db handler prepare  SHOW tables    sql 1 execute tables   sql 1 map    row  row 0   sql 1 finish  tables each do  table name    sql 2   db handler prepare  SELECT count    FROM   table name       sql 2 execute   sql 2 each do  row      puts  Table   table name  has   row 0   rows     end   sql 2 finish end  db handler disconnect   Go back to the command-line     gt  ruby count table records rb   Output   Table users has 7328974 rows

User · Answer

Like  Venkatramanan and others I found INFORMATION SCHEMA TABLES unreliable  using InnoDB  MySQL 5 1 44   giving different row counts each time I run it even on quiesced tables  Here s a relatively hacky  but flexible adaptable  way of generating a big SQL statement you can paste into a new query  without installing Ruby gems and stuff   SELECT CONCAT       SELECT          table name          AS table name  COUNT    AS exact row count FROM          table schema                 table name          UNION      FROM INFORMATION SCHEMA TABLES  WHERE table schema      my schema       It produces output like this   SELECT  func  AS table name  COUNT    AS exact row count FROM my schema func UNION                          SELECT  general log  AS table name  COUNT    AS exact row count FROM my schema general log UNION            SELECT  help category  AS table name  COUNT    AS exact row count FROM my schema help category UNION        SELECT  help keyword  AS table name  COUNT    AS exact row count FROM my schema help keyword UNION          SELECT  help relation  AS table name  COUNT    AS exact row count FROM my schema help relation UNION        SELECT  help topic  AS table name  COUNT    AS exact row count FROM my schema help topic UNION              SELECT  host  AS table name  COUNT    AS exact row count FROM my schema host UNION                          SELECT  ndb binlog index  AS table name  COUNT    AS exact row count FROM my schema ndb binlog index UNION    Copy and paste except for the last UNION to get nice output like    ------------------ -----------------    table name         exact row count    ------------------ -----------------    func                             0     general log                      0     help category                   37     help keyword                   450     help relation                  990     help topic                     504     host                             0     ndb binlog index                 0    ------------------ -----------------  8 rows in set  0 01 sec

User · Answer

SELECT SUM TABLE ROWS        FROM INFORMATION SCHEMA TABLES       WHERE TABLE SCHEMA     your db      Note from the docs though  For InnoDB tables  the row count is only a rough estimate used in SQL optimization  You ll need to use COUNT    for exact counts  which is more expensive

User · Answer

If you know the number of tables and their names  and assuming they each have primary keys  you can use a cross join in combination with COUNT distinct  column   to get the rows that come from each table   SELECT     COUNT distinct t1 id        COUNT distinct t2 id        COUNT distinct t3 id  AS totalRows FROM firstTable t1  secondTable t2  thirdTable t3    Here is an SQL Fiddle example

User · Answer

SELECT TABLE NAME SUM TABLE ROWS    FROM INFORMATION SCHEMA TABLES   WHERE TABLE SCHEMA    your db    GROUP BY TABLE NAME    That s all you need

User · Answer

You can probably put something together with Tables table   I ve never done it  but it looks like it has a column for TABLE ROWS and one for TABLE NAME     To get rows per table  you can use a query like this     SELECT table name  table rows FROM INFORMATION SCHEMA TABLES WHERE TABLE SCHEMA      YOUR SCHEMA

User · Answer

If you use the database information schema  you can use this mysql code  the where part makes the query not show tables that have a null value for rows    SELECT TABLE NAME  TABLE ROWS FROM  TABLES  WHERE  TABLE ROWS   gt  0

[mysql] Get record counts for all tables in MySQL database

Examples related to mysql

Examples related to sql

Examples related to rowcount