Link to home
Start Free TrialLog in
Avatar of karthik80c
karthik80cFlag for United States of America

asked on

it is possible to return all null values and their column name in row wise in mysql ?

Hi its possible to return null values and their column names in row wise or to return not-null values and their column names in row wise in mysql
Avatar of arnold
arnold
Flag of United States of America image

What do you mean.  Are you looking to a where column is null?
Or you want to do a select where the only thing you get us column,null.?
Avatar of karthik80c

ASKER

i have a maximum of 80 to 90 columns in my table in that i want to know what are the fields are empty in that particular row . so that next time we can update in the empty field. its possible?
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial