Home / Uncategories / Get rows of all tables

Get rows of all tables

Edit
SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db-name' ORDER BY table_rows DESC LIMIT 100
Share on Google Plus

About Admin

Arun is a JAVA/J2EE developer and passionate about coding and managing technical team.
    Blogger Comment
    Facebook Comment

3 comments:

  1. Harminder Singh3 July 2018 at 13:57

    Very informative ! Indian cyber Army gives Best Ethical Hacking Training in noida in view of current industry principles that causes participants to anchor positions in their fantasy occupations at MNCs.

    ReplyDelete
  2. Anonymous18 March 2019 at 21:27

    Nice hack.. good interview question to test DB knowledge of candidate.

    ReplyDelete
  3. ravisynit22 August 2020 at 14:32

    thanks for tips at SynergisticIT offer the best H1b filing and job placement

    ReplyDelete

Subscribe to: Post Comments ( Atom )