mysql 不显示列名_如何在MySQL中获取值不为空的列名

I have a table which has a single entry. I have to get those column values whose values are not null. Please suggest me query for MySQL so I can implement this. My table is :

In this table 3 columns have Null values. So I don't want these columns, query should return values which in not null.

Can I get the column name also? Like I want to get name of the column i.e min_p5 whose value is not null. So I can break the column name into strings and use 5 in my calculation. Please suggest me answer.

解决方案

I think this is what you need:

Assuming your table name to be "orders" [pls change it accordingly]

$q="show columns from orders";

$res=mysql_query($q) or die(mysql_error());

$arr_field=array();

while($row=mysql_fetch_object($res)){

$field=$row->Field;

$q1="select ".$field." from orders where ".$field."!=0"; //if string then '0'

$res1=mysql_query($q1) or die(mysql_error());

if(mysql_num_rows($res1)>0){

$arr_field[]=$field;

}

}

$q="select ";

foreach($arr_field as $field){

$q.=$field.",";

}

$q=rtrim($q,",");

$q.=" from orders";

$res=mysql_query($q) or die(mysql_error());

while($row=mysql_fetch_object($res)){

foreach($arr_field as $field){

print($field."==".$row->$field."
");

}

}

Run this and I hope you will get an idea...