Removing NULL values from columns (MySQL) -


so have table 4 columns (c1, c2, c3 , c4) , of fields in these columns have null values. want trim/remove these null values without having remove whole column or row (i.e. null value). instance, if have:

c1: 1 2 3 null null 7 9 2 null c2: null null null 4 5 3 null null 

i want show this:

c1: 1 2 3 7 9 2 c2: 4 5 3 

thanks in advance guys!


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -