mysql - Size of perticular rows of table which satisfy condition -


select (data_length)'size'  information_schema.tables  table_name='abc' 

this giving me total data size of table "abc". want data size of particular rows satisfy condition in clause.

say,

select (data_length)'size'  information_schema.tables  table_name='abc' , abc.id=1 

so,i want data_length of rows satisfies condition,but above not working.

i guess understand query.


Comments

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

Making Empty C++ Project: General exception (Exception from HRESULT:0x80131500) Visual Studio Community 2015 -

How to fix java warning for "The value of the local variable is not used " -