how to count size of every row in mysql database table??? Is it possible? If yes then

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • radiantsoft
    New Member
    • Jul 2015
    • 2

    how to count size of every row in mysql database table??? Is it possible? If yes then

    I want to count size of all rows in mysql table? is it possible? how?
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    Code:
    SELECT SUM(AVG_ROW_LENGTH*TABLE_ROWS) 
    FROM information_schema.tables
    WHERE TABLE_NAME='yourTableName';

    Comment

    Working...