list
Subject: Re: [PHP] PHP/mySQL question about groups
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company
that
developed and marketed another database server, comparing the query plan
to
the actual code
On Feb 7, 2008 1:20 AM, Warren Vail [EMAIL PROTECTED] wrote:
I did some looking into performance issues many years ago at company that
developed and marketed another database server, comparing the query plan to
the actual code, and a query plan usually shows the processes that consume
the
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
data that looks like this:
wineidname size
123 Silver Oak 750ML
123
On Feb 6, 2008 8:46 PM, Rob Gould [EMAIL PROTECTED] wrote:
Let's say I have a PHP-based wine application, and it's taking a set of
mySQL data that looks like this:
wineidname
size
123 Silver Oak
750ML
123
Select * from wine where name = 'Silver Oak' GROUP BY wineid,size
bastien Date: Wed, 6 Feb 2008 17:46:52 -0800 From: [EMAIL PROTECTED] To:
php-general@lists.php.net Subject: [PHP] PHP/mySQL question about groups
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
On Feb 6, 2008 8:46 PM, Rob Gould [EMAIL PROTECTED] wrote:
Let's say I have a PHP-based wine application, and it's taking a set of mySQL
data that looks like this:
wineidname
size
123 Silver Oak
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL PROTECTED] wrote:
Of course, in this case you could just avoid all the confusion with
this statement as well:
SELECT DISTINCT name, size
FROMwine
im not sure why, but i think distinct is typically way slower than group by.
-nathan
On Feb 6, 2008 11:20 PM, Nathan Nobbe [EMAIL PROTECTED] wrote:
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL PROTECTED] wrote:
Of course, in this case you could just avoid all the confusion with
this statement as well:
SELECT DISTINCT name, size
FROMwine
im not sure why, but i
-Original Message-
From: Andrew Ballard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 06, 2008 8:41 PM
To: PHP General list
Subject: Re: [PHP] PHP/mySQL question about groups
On Feb 6, 2008 11:20 PM, Nathan Nobbe [EMAIL PROTECTED] wrote:
On Feb 6, 2008 10:59 PM, Andrew Ballard [EMAIL
9 matches
Mail list logo