By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

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

P: 2
I want to count size of all rows in mysql table? is it possible? how?
Jul 25 '15 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,035
Expand|Select|Wrap|Line Numbers
  1. SELECT SUM(AVG_ROW_LENGTH*TABLE_ROWS) 
  2. FROM information_schema.tables
  3. WHERE TABLE_NAME='yourTableName';
  4.  
Jul 25 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.