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

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

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

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

mysql (1)

259 комментариев к “Выводим список таблиц с количеством записей в 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!

  5. Great post. I was checking constantly this blog and I am impressed!

    Extremely useful info specially the ultimate phase 🙂 I care for such information a lot.
    I used to be looking for this certain information for a very lengthy time.
    Thanks and good luck.

  6. Unquestionably believe that which you stated.

    Your favorite reason appeared to be on the internet the simplest
    thing to be aware of. I say to you, I definitely get
    annoyed while people consider worries that they plainly do not know about.
    You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people can take a signal.
    Will likely be back to get more. Thanks

  7. Hi there! I know this is kinda off topic nevertheless I’d
    figured I’d ask. Would you be interested in trading links
    or maybe guest writing a blog post or vice-versa?
    My site addresses a lot of the same topics as yours and I believe
    we could greatly benefit from each other. If you
    are interested feel free to send me an email. I look forward to hearing from you!
    Wonderful blog by the way!

  8. Hello! I could have sworn I’ve been to this blog before but after looking at some of
    the articles I realized it’s new to me. Anyways, I’m definitely happy I discovered it and I’ll be
    bookmarking it and checking back frequently!

  9. Today, I went to the beachfront with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.”
    She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is completely off topic
    but I had to tell someone!

  10. Hey there, I think your blog might be having browser compatibility issues.
    When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has
    some overlapping. I just wanted to give you a quick
    heads up! Other then that, fantastic blog!

  11. Hey there outstanding blog! Does running a blog similar to
    this require a massive amount work? I’ve absolutely no understanding of coding however I was hoping to start my own blog soon. Anyways, should you have
    any ideas or techniques for new blog owners please share.

    I understand this is off subject but I just needed to ask.

    Thanks!

  12. Hiya very cool blog!! Guy .. Beautiful .. Wonderful .. I’ll bookmark your web site and take the
    feeds additionally? I am glad to seek out a lot of useful information here in the post, we need develop extra
    strategies in this regard, thank you for sharing. . . . . .

  13. After I originally commented I seem to have clicked the -Notify me
    when new comments are added- checkbox and from now on whenever a
    comment is added I get 4 emails with the exact same comment.

    Perhaps there is a means you can remove me from that service?
    Thanks a lot!

  14. First off I would like to say fantastic blog! I had a
    quick question in which I’d like to ask if you don’t
    mind. I was interested to know how you center yourself and clear your head before writing.
    I have had a difficult time clearing my thoughts in getting my ideas
    out there. I truly do enjoy writing however it just seems like the first 10 to 15
    minutes are usually wasted simply just trying to figure out how to begin. Any recommendations or tips?
    Thanks!

  15. Hi there, I do think your website could possibly be having internet browser compatibility
    problems. Whenever I look at your web site in Safari, it
    looks fine but when opening in I.E., it has some overlapping issues.
    I just wanted to give you a quick heads up! Aside from that, fantastic site!

  16. Hi! Quick question that’s completely off
    topic. Do you know how to make your site mobile
    friendly? My website looks weird when browsing from my iphone 4.
    I’m trying to find a theme or plugin that
    might be able to resolve this problem. If you have any suggestions, please
    share. Thanks!

  17. Hey! Someone in my Facebook group shared this site with us so I came to
    take a look. I’m definitely enjoying the information. I’m bookmarking and will
    be tweeting this to my followers! Terrific blog and amazing
    style and design.

  18. Pretty nice post. I simply stumbled upon your blog and wanted to mention that
    I’ve really enjoyed browsing your blog posts. After all I will
    be subscribing on your feed and I am hoping you write once more very soon!

  19. Pretty element of content. I simply stumbled upon your web site and in accession capital to say that I acquire actually loved account your weblog
    posts. Anyway I will be subscribing to your feeds or even I success you get admission to consistently fast.

  20. I blog quite often and I truly appreciate your information. The article has truly peaked my interest.
    I will bookmark your website and keep checking for new
    details about once a week. I opted in for your RSS feed too.

  21. Hi there, I found your website by the use of Google whilst searching for a related matter, your web site got here up, it
    appears to be like great. I’ve bookmarked it in my google bookmarks.

    Hi there, simply was alert to your blog through Google, and
    located that it is really informative. I’m gonna be careful for brussels.
    I will be grateful if you happen to proceed this in future.
    Many other people might be benefited from your writing.
    Cheers!

  22. I am really loving the theme/design of your web site. Do you ever run into any browser compatibility
    problems? A handful of my blog visitors have complained about
    my website not working correctly in Explorer but looks great in Firefox.
    Do you have any recommendations to help fix this issue?

  23. I was suggested this web site by my cousin. I’m not sure whether this post is written by him as no one else know such detailed about my
    trouble. You are amazing! Thanks!

  24. Hi there! This blog post couldn’t be written much better!
    Reading through this post reminds me of my
    previous roommate! He continually kept preaching about this.
    I most certainly will send this information to him.
    Pretty sure he will have a very good read. I appreciate
    you for sharing!

  25. I’m very pleased to uncover this website. I wanted to thank you for your time due to this fantastic read!!
    I definitely appreciated every little bit of it and i also have you
    saved as a favorite to see new information in your website.

  26. Aw, this was a really nice post. Finding the time
    and actual effort to make a really good article… but what can I say… I hesitate a lot and never seem to get nearly anything done.

  27. Yesterday, while I was at work, my sister stole my apple ipad
    and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and
    she has 83 views. I know this is completely off
    topic but I had to share it with someone!

  28. Terrific work! This is the type of info that are meant to be shared across the internet.
    Disgrace on the seek engines for not positioning this publish higher!

    Come on over and consult with my website . Thank you =)

  29. Good day very cool blog!! Man .. Excellent ..
    Amazing .. I’ll bookmark your website and take
    the feeds additionally? I’m satisfied to find a lot of useful
    info here in the post, we want develop more techniques
    on this regard, thank you for sharing. . .
    . . .

  30. This design is steller! You obviously 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!) Wonderful job. I really enjoyed what
    you had to say, and more than that, how you presented it.
    Too cool!

  31. Someone essentially lend a hand to make seriously posts
    I might state. This is the first time I frequented your website page and to this point?
    I amazed with the research you made to make this particular publish incredible.
    Wonderful process!

  32. Wonderful blog! I found it while surfing around on Yahoo News.
    Do you have any suggestions on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!
    Cheers

  33. Wonderful blog! I found it while surfing around on Yahoo News.
    Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!
    Thank you

  34. I will right away snatch your rss feed as
    I can not find your e-mail subscription link or e-newsletter service.

    Do you’ve any? Please permit me understand so that I may just subscribe.

    Thanks.

  35. I don’t know if it’s just me or if everyone else experiencing problems with your
    website. It looks like some of the text within your posts are running off the
    screen. Can somebody else please provide feedback and let me know if this is happening to them too?

    This might be a issue with my browser because I’ve had this happen previously.
    Thanks

  36. I believe everything said was very logical. However, what about this?
    what if you added a little content? I ain’t suggesting your information isn’t good,
    however what if you added a post title to maybe grab folk’s attention? I mean Выводим список
    таблиц с количеством записей
    в mysql – VOIP-LAB is a little vanilla.
    You might glance at Yahoo’s home page and see how they write post headlines to grab viewers to open the links.

    You might add a related video or a related picture or two to
    get readers interested about what you’ve got to say. In my opinion, it might make your website a little livelier.

  37. Hello there! I know this is somewhat off topic but I
    was wondering which blog platform are you using for
    this site? I’m getting sick and tired of WordPress because I’ve
    had issues with hackers and I’m looking at alternatives for another platform.
    I would be awesome if you could point me in the direction of a good platform.

  38. Hey there this is kinda of off topic but I was wondering if blogs use
    WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding expertise
    so I wanted to get advice from someone with experience. Any help
    would be enormously appreciated!

  39. Hello, I do think your site could possibly be having browser
    compatibility problems. When I take a look at your site in Safari, it looks fine however, if opening
    in Internet Explorer, it has some overlapping issues.
    I merely wanted to give you a quick heads up!
    Other than that, wonderful blog!

  40. Nice post. I was checking continuously this weblog and I’m inspired!
    Extremely useful info specifically the final section :
    ) I care for such information much. I used to be seeking
    this certain information for a long time. Thank you and best of luck.

  41. It is perfect time to make some plans for the future and it
    is time to be happy. I have read this submit and if I may I
    wish to counsel you some fascinating issues or suggestions.
    Maybe you could write subsequent articles relating to this article.
    I wish to learn more issues about it!

  42. Today, I went to the beach with my children. I found
    a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed
    the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is completely off topic
    but I had to tell someone!

  43. With havin so much content and articles do you ever run into any problems of plagorism or copyright violation?
    My blog has a lot of unique content I’ve either written myself or outsourced
    but it seems a lot of it is popping it up all over the web without my permission. Do you know any ways to
    help stop content from being ripped off? I’d genuinely appreciate it.

  44. What i don’t understood is in truth how you are not really much more well-preferred than you may be now.
    You’re so intelligent. You already know therefore considerably relating to
    this subject, made me in my opinion imagine it from so
    many numerous angles. Its like men and women don’t seem to be fascinated until it is something to do with Lady gaga!
    Your own stuffs great. All the time handle it
    up!

  45. Hey I am so thrilled I found your blog page, I really found you by accident, while I was searching on Yahoo for something else, Regardless I am here now and would just like to say many thanks for
    a marvelous post and a all round interesting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have saved it and also included
    your RSS feeds, so when I have time I will be back to read much more, Please do keep up the superb work.

  46. This design is spectacular! You obviously 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!) Excellent job. I really enjoyed what you had to say,
    and more than that, how you presented it. Too
    cool!

  47. You’re so awesome! I do not suppose I’ve truly read through a single thing like that before.
    So nice to find somebody with unique thoughts
    on this subject matter. Really.. thanks for starting this up.
    This site is something that is needed on the internet, someone with a bit of originality!

  48. I’m no longer positive where you’re getting your info,
    however good topic. I must spend some time studying more or understanding more.

    Thanks for great info I used to be searching for this information for my mission.

  49. I was curious if you ever thought of changing the
    layout of your website? Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so
    people could connect with it better. Youve got an awful lot of text for only having one or two
    pictures. Maybe you could space it out better?

  50. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.
    You obviously know what youre talking about, why throw away your
    intelligence on just posting videos to your weblog when you could be giving
    us something enlightening to read?

  51. I don’t know if it’s just me or if everybody else experiencing issues
    with your site. It looks like some of the written text in your content
    are running off the screen. Can somebody else please provide feedback and let me know if this is happening to
    them too? This may be a issue with my web browser
    because I’ve had this happen previously. Kudos

  52. Today, I went to the beach with my kids. I found a sea shell and gave
    it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the
    shell to her ear and screamed. There was a hermit crab inside and it pinched her ear.

    She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  53. What i do not understood is if truth be told how you are not actually
    much more neatly-favored than you may be
    now. You are so intelligent. You realize therefore significantly in relation to this subject, produced me
    in my opinion imagine it from so many numerous angles.
    Its like women and men are not involved unless it is one thing to accomplish with Girl gaga!
    Your own stuffs excellent. All the time care for it up!

  54. I think that is one of the so much vital information for me.
    And i’m glad studying your article. But want to remark on some normal issues, The site taste is perfect, the articles is in reality great : D.
    Good activity, cheers

  55. I used to be recommended this web site by my cousin.
    I am now not positive whether this post is written by him as nobody else recognize such specified approximately my trouble.
    You’re incredible! Thanks!

  56. Hmm is anyone else encountering problems with the pictures
    on this blog loading? I’m trying to figure out if its a problem on my end or
    if it’s the blog. Any responses would be greatly appreciated.

  57. Great post. I was checking constantly this blog and I’m impressed!

    Very useful information specifically the last part 🙂 I care for such information much.
    I was seeking this certain info for a very long time.
    Thank you and good luck.

  58. Aw, this was a really good post. Taking a few minutes
    and actual effort to make a top notch article… but what can I
    say… I put things off a lot and don’t seem to get nearly anything done.

  59. Magnificent beat ! I wishh to apprentice whilst you amend your site, how
    could i subscribe for a weblog website? The account aided
    mee a applicable deal. I had been tiny biit acquainted of this your broadcast providesd vibrant
    transparent idea

  60. Thanks for one’s marvelous posting! I quite enjoyed reading it,
    you happen to bee a great author.I will make certain to bookmark
    your blog and will often come back in the
    future. I want tto encourage yourself to continue
    your great posts, have a nice afternoon!

  61. Hi there very cool site!! Guy .. Excellent ..
    Superb .. I’ll bookmark your site and take the feeds
    additionally? I am happy to seek out so many useful information right here in the putt up, we want develop extra strategies in this regard, thank you forr sharing.
    . . . . .

  62. I just want to tell you that I am just new to weblog and actually loved you’re web site. Probably I’m going to bookmark your site . You really have exceptional stories. Thanks a lot for revealing your website.

  63. obviously like your website however you need to check the spelling on several of your posts. Several of them are rife with spelling problems and I in finding it very bothersome to inform the reality then again I’ll certainly come back again.

  64. I simply want to say I’m very new to blogging and site-building and really loved you’re blog site. Likely I’m going to bookmark your blog post . You certainly have great articles. Appreciate it for revealing your blog.

  65. Great blog! Do you have any helpful hints for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m totally overwhelmed .. Any tips? Bless you!

  66. I have recently started a web site, the info you offer on this web site has helped me greatly. Thank you for all of your time & work. “My dear and old country, here we are once again together faced with a heavy trial.” by Charles De Gaulle.

  67. I simply want to mention I am just newbie to blogging and site-building and really loved your web page. Probably I’m going to bookmark your website . You certainly have perfect well written articles. Kudos for sharing your web site.

  68. Hi, Neat post. There’s a problem along with your site in web explorer, might test this… IE still is the market chief and a big component of other people will leave out your wonderful writing due to this problem.

  69. I intended to post you a tiny observation to finally say thank you the moment again relating to the marvelous secrets you have discussed above. It has been really remarkably generous with you to deliver publicly precisely what a few people would’ve supplied as an e book to help with making some bucks for their own end, certainly given that you could possibly have tried it if you decided. The tips in addition worked to be the easy way to be sure that the rest have the identical keenness like my personal own to understand great deal more with regards to this issue. Certainly there are thousands of more pleasurable sessions up front for folks who scan through your website.

  70. hey there and thank you for your info – I’ve certainly picked up something new from right here. I did however expertise some technical issues using this website, since I experienced to reload the web site lots of times previous to I could get it to load correctly. I had been wondering if your web hosting is OK? Not that I’m complaining, but sluggish loading instances times will very frequently affect your placement in google and can damage your high-quality score if ads and marketing with Adwords. Anyway I’m adding this RSS to my email and could look out for much more of your respective interesting content. Make sure you update this again soon..

  71. I simply want to tell you that I’m all new to blogs and absolutely savored you’re page. More than likely I’m want to bookmark your blog post . You certainly come with really good well written articles. Thanks a lot for revealing your blog site.

  72. Virtually all of the things you mention is astonishingly appropriate and it makes me ponder the reason why I had not looked at this with this light before. This piece really did switch the light on for me as far as this particular issue goes. However there is one factor I am not really too cozy with so whilst I try to reconcile that with the central theme of the issue, permit me see just what all the rest of your readers have to point out.Nicely done.

  73. Thanks for discussing your ideas. I’d also like to convey that video games have been ever evolving. Modern technology and improvements have made it simpler to create genuine and fun games. Most of these entertainment video games were not actually sensible when the actual concept was first of all being used. Just like other forms of technological know-how, video games as well have had to develop through many ages. This is testimony towards the fast continuing development of video games.

  74. Its such as you read my thoughts! You appear to grasp so much about this, like you wrote the book in it or something. I think that you could do with some percent to power the message home a bit, but other than that, this is wonderful blog. A fantastic read. I will certainly be back.

  75. I don’t accept as true with this particular blog post. Nonetheless, I did searched with Google and I’ve found out that you’re correct and I seemed to be thinking in the wrong way. Carry on publishing top quality articles like this.

  76. After looking at a few of the blog posts on your web page, I really like your technique of blogging. I added it to my bookmark webpage list and will be checking back in the near future. Please visit my web site too and tell me how you feel.

  77. I just want to say I am very new to blogging and site-building and really enjoyed this website. Very likely I’m want to bookmark your website . You really have excellent stories. Kudos for sharing your web site.

  78. Hi, I do think this is a great site. I stumbledupon it 😉 I’m going to revisit once again since I saved as a favorite it. Money and freedom is the greatest way to change, may you be rich and continue to help other people.

  79. Great beat ! I wish to apprentice while you amend your website, how could i subscribe for a blog web site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear idea

  80. Excellent post. I was checking continuously this weblog and I am impressed! Very helpful info specifically the closing phase 🙂 I handle such info a lot. I used to be looking for this particular information for a very long time. Thanks and best of luck.

  81. I feel that is one of the most important information for me. And i am happy studying your article. But should commentary on few normal issues, The website style is wonderful, the articles is in point of fact great : D. Good process, cheers

  82. Pretty nice post. I just stumbled upon your blog and wished to say that I have truly enjoyed surfing around your blog posts. In any case I will be subscribing to your rss feed and I hope you write again soon!

  83. I happen to be commenting to let you be aware of of the helpful encounter my friend’s child had reading the blog. She picked up plenty of issues, most notably what it’s like to have a marvelous teaching style to make many people with no trouble comprehend a variety of grueling things. You really surpassed people’s expectations. Thanks for supplying the informative, dependable, revealing not to mention easy guidance on this topic to Julie.

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

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