How to get record size in MySql if the table contains fields of type TEXT or BLOB?
Is it possible to get the size of a record or table using the sql statement?
To calculate the size of a string or blob in bytes, use LENGTH(YourColumn) .
LENGTH(YourColumn)
To calculate the number of characters in a text string, use CHAR_LENGTH(YourTextColumn) .
CHAR_LENGTH(YourTextColumn)
Source: https://habr.com/ru/post/1305923/More articles:Open interactive color theme selection - javascriptWhat can map database tables like LINQ to SQL? - linqA method that causes a conditional return of a method that calls it? - c #How can I do block oriented disk I / O using Java? Or similar for B + tree - javaConditional operator in C - csharing pthread data and child processes in C - cDate date function in .NET. - datetimeRegarding getting links to the IDot11AdHocManager interface of the COM WiFi AdHoc interface - c ++Use WixUIBannerBmp in my custom dialog - wixClearing a string consisting of html / server-side tags in Java - javaAll Articles