how to count size of table records

Question

hii... i have an mysql database. In that db one table saves records of many members. Nowin asp.net... if insert any member id I want to know to count total size used by that user. Is it possible???How???

Amitesh Verma · Answer

http://www.sqlmatters.com/Articles/Listing%20all%20tables%20in%20a%20database%20and%20their%20row%20counts%20and%20sizes.aspx CREATE TABLE #RowCountsAndSizes ( TableName NVARCHAR ( 128 ) rows CHAR ( 11 ) reserved VARCHAR ( 18 ) data VARCHAR ( 18 ) index_size VARCHAR ( 18 ) unused VARCHAR ( 18 )) EXEC sp_MSForEachTable 'INSERT INTO #RowCountsAndSizes EXEC sp_spaceused ''?'' ' SELECT TableName  CONVERT ( bigint  rows ) AS NumberOfRows  CONVERT ( bigint left( reserved  len ( reserved )- 3 )) AS SizeinKB FROM #RowCountsAndSizes ORDER BY NumberOfRows DESC  SizeinKB DESC  TableName DROP TABLE #RowCountsAndSizes

Radiant Software · Answer

hi Roshan Patil.... I want to count size of row on disk from database. can u help me???

Roshan Patil · Answer

select count(*) from member_table where member_id=123 this will give all records for member_id=123 in member_table