我“分组依据”我的数据库中的所有交易按商店。如何显示查询后未分组的所有其他交易?这是我正在使用的查询:
$query = mysql_query("SELECT * FROM deals WHERE DATE_FORMAT(expiration_date,'%Y-%m-%d %H:%i:%s') >= NOW() $cat ORDER BY deal_id ASC") or die(mysql_error());
php $table = 'artwork';
$result = mysql_query("select AID, ThumbFilePath, Title, DisplayOrder from artwork where SCID = $SCID order by DisplayOrder") or die(mysql_error());while($row = mysql_fetch_array($resu
下面是我的问题from optional_system_step as ssjoin category_description as cd on cd.category_id=ss.category_id
join optional_system_step_product as ssp on ss.system
它正在生成一个巨大的查询,在这个查询中,我注意到有一个WHERE语句重复自己,其中语句的顺序似乎非常重要。我相信这与MySQL如何分组WHERE语句有关,但我不明白MySQL是如何工作的。mysql是如何解释/分组这个的?MySQL将WHERE语句分组如下:
SELECT * FROM campaigns WHERE status = 1 OR (id IN ('20') AND status = 1);