Is there a way to find out the size of all the data in a MySQL query? For example if I had the query "SELECT * FROM accounts" is there a way I could find the total size of the data returned in that query?
Thanks for any help.
Do you mean the size in bytes or the number of rows returned?
http://uk.php.net/manual/en/function.mysql-num-rows.php to get the number of rows
http://uk.php.net/manual/en/function.mysql-fetch-lengths.php to get the length of each field in a row as an array
work it out for yourself
