How to get the byte size of resultset in an SQL query?

by 
select sum(row_size) 
from (
  select 
    char_length(column1)+
    char_length(column2)+
    char_length(column3)+
    char_length(column4) ... <-- repeat for all columns
  as row_size 
  from your_table
) as tbl1;

char_length for enum, set might not accurate, please take note

More Related Contents:

  1. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  2. You can’t specify target table for update in FROM clause
  3. Generating a range of numbers in MySQL
  4. How to get next/previous record in MySQL?
  5. How do I make a row generator in MySQL?
  6. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  7. MySQL number of items within “in clause”
  8. Error 1046 No database Selected, how to resolve?
  9. What’s the difference between VARCHAR and CHAR?
  10. Alter a MySQL column to be AUTO_INCREMENT
  11. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  12. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  13. single fixed table with multiple columns vs flexible abstract tables
  14. How many rows in a database are TOO MANY?
  15. MySQL remove duplicates from big database quick
  16. mysql, iterate through column names
  17. How to delete from select in MySQL?
  18. How to delete Duplicates in MySQL table
  19. How to ORDER BY a SUM() in MySQL?
  20. mySQL Returning the top 5 of each category
  21. Selecting Random Rows in MySQL
  22. mysql – how many columns is too many?
  23. Error: The used SELECT statements have a different number of columns
  24. How to Optimize Queries in a Database – The Basics
  25. Any way to achieve fulltext-like search on InnoDB
  26. Create date from day, month, year fields in MySQL
  27. Can I use a MySQL database with an App Engine application
  28. How to combine aggregate functions in MySQL?
  29. I want to copy table contained from one database and insert onto another database table
  30. Why are batch inserts/updates faster? How do batch updates work?

Leave a Comment