Выводим список таблиц с количеством записей в mysql

Хочу привести небольшой пример запроса, с помощью которого можно получить список таблиц в mysql базе с количеством записей :

SELECT table_name, table_rows 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = '**YOUR DATABASE**';

Вывод будет примерно таким:

mysql (1)

9 комментариев к “Выводим список таблиц с количеством записей в mysql

  1. Excellent weblog here! Also your site rather a lot up fast!
    What web host are you using? Can I am getting your associate link for your host?

    I wish my site loaded up as quickly as yours lol
    2CSYEon cheap flights

  2. Terrific work! This is the type of information that are supposed to be
    shared across the web. Shame on the seek engines for not positioning this submit upper!
    Come on over and seek advice from my web site .
    Thanks =)

  3. Nice post. I was checking constantly this weblog
    and I’m inspired! Very helpful info specifically the ultimate section :
    ) I take care of such information a lot. I was seeking this particular info for a
    long time. Thanks and best of luck.

  4. Howdy! This is my first comment here so I just wanted
    to give a quick shout out and say I really enjoy reading through your blog posts.
    Can you recommend any other blogs/websites/forums that
    cover the same subjects? Thank you!

Оставить ответ

Ваш адрес email не будет опубликован. Обязательные поля помечены *