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

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

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

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

mysql (1)

Рекомендуем почитать
Чистим историю в базе данных zabbix

Ни для кого не секрет , что со временем база данных zabbix увеличивается. Поэтому покажу вам как ее почистить в Читать дальше...

Узнать размеры всех баз mysql

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( Читать дальше...

Как сделать резервную копию MySql всех баз данных

Хочу поделится с вами небольшим скриптом для создания резервных копий всех баз данных MySql. #!/bin/bash MyUSER="dbuser" MyPASS="dbpass" MyHOST="localhost" MYSQL="$(which mysql)" Читать дальше...

Бесплатный доступ к платным сервисам во время эпидемии коронавируса

Безусловно, коронавирус повлияет на нас всех в той или иной форме. Ничего хорошего от него нет, не было и не Читать дальше...

Поделиться

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

  1. Undeniably believe that that you said. Your favourite justification seemed to be at the internet the simplest factor to
    be aware of. I say to you, I definitely get irked whilst
    other folks think about issues that they plainly don’t realize about.
    You controlled to hit the nail upon the top as neatly as defined out the entire thing with
    no need side effect , people could take a signal.
    Will probably be again to get more. Thanks

  2. Have you ever considered creating an e-book
    or guest authoring on other websites? I have a blog based upon on the same ideas you discuss and would really like
    to have you share some stories/information. I know my visitors would
    enjoy your work. If you are even remotely interested, feel
    free to shoot me an email.

  3. Hi, I do think this is a great web site. I stumbledupon it 😉 I will revisit yet again since I
    book-marked it. Money and freedom is the best way to change, may
    you be rich and continue to help other people.

  4. I have been browsing online more than three hours today,
    yet I never found any interesting article like yours.

    It is pretty worth enough for me. In my opinion, if all
    website owners and bloggers made good content as you did, the net will be much more
    useful than ever before.

  5. Hi! I could have sworn I’ve visited this site before but
    after looking at some of the posts I realized it’s new to me.
    Nonetheless, I’m definitely happy I found it and I’ll be bookmarking it and
    checking back frequently!

  6. Please let me know if you’re looking for a article writer for your weblog.
    You have some really good articles and I feel I would be a good
    asset. If you ever want to take some of the load off,
    I’d really like to write some content for your blog in exchange
    for a link back to mine. Please send me an email if interested.
    Thanks!

  7. I have been browsing online greater than 3 hours as of late, yet I never discovered any fascinating
    article like yours. It’s beautiful value sufficient for me.

    In my opinion, if all website owners and bloggers made just right
    content as you did, the net will probably be much more helpful than ever before.

  8. This design is spectacular! You definitely know how to keep a reader amused.
    Between your wit and your videos, I was almost moved to start my
    own blog (well, almost…HaHa!) Fantastic job. I really enjoyed
    what you had to say, and more than that, how you presented it.

    Too cool!

  9. Simply desire to say your article is as surprising. The clarity in your post is simply nice
    and i could assume you are an expert on this subject.
    Fine with your permission allow me to grab your feed to
    keep up to date with forthcoming post. Thanks
    a million and please carry on the gratifying work.

Оставить ответ к g more Отменить ответ

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