MySQL强制查询返回NULL [英] MySQL force query to return NULL
本文介绍了MySQL强制查询返回NULL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下几点:
SELECT q25, COUNT( q25 ) AS count, AVG (q1) AS q1
FROM tresults WHERE id = 'Yes' AND date = 'MARCH2010' AND q25 = '1'
GROUP BY q25
目前,查询返回 MySQL 返回一个空结果集(即零行).
这是正确的 - 是否有可能让它返回 NULL
代替?
At the moment, the query returns MySQL returned an empty result set (i.e. zero rows).
which is correct - is it possible to get it to return NULL
instead?
或
PHP中有没有办法在事件之后处理这个,比如:
Is there a way of dealing with this after the event in PHP, such as:
$resultprev = mysql_query($queryprev);
if($resultprev == ''){
// do something
}
推荐答案
use mysql_num_rows :
$resultprev = mysql_query($queryprev);
$num_rows = mysql_num_rows($resultprev);
if($num_rows == 0){
// 0 results !
}
或者你可以联合一个空行:
or you could union a null row :
SELECT q25, COUNT( q25 ) AS count, AVG (q1) AS q1
FROM tresults WHERE id = 'Yes' AND date = 'MARCH2010' AND q25 = '1'
GROUP BY q25
UNION
SELECT null, null as count, null as q1
这篇关于MySQL强制查询返回NULL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文