I am using mysql, I have liferay in that I have a table called holidays (it contains holiday dates of a particular month) and I want to find the size of each record in the holiday table.
For example:
1aug2015-0.3MB..till 31aug2015.
Asked
Active
Viewed 159 times
2
-
I am not sure its work or not . Check this -> SELECT LENGTH(`month`)/CHAR_LENGTH(`month`) kb FROM `holidays` – Suraj Jun 05 '15 at 10:29
-
Thank you again, it is also giving the size of the table – Arya Jun 05 '15 at 10:40
-
I would remove the reference to Liferay, as this has nothing to do with it. – Tobias Liefke Jun 05 '15 at 12:43
1 Answers
1
I am not sure if there is a direct method to get a record/row size. But I think you can get the table size and divide it by the number of rows to get the average size of a record.
You may check this answer of How to get the sizes of the tables of a MySQL database?.
Community
- 1
- 1
Lamya Elmorsy
- 341
- 4
- 13
-
thank you for the reply, I did the same thing, but there are some empty records in the table, so my teacher said that method is not correct for all records. – Arya Jun 05 '15 at 10:21