Re: mysql - SELECT DISTINCT problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Very odd.  I would think it would return every record seeing as the auto_increment ID field is different for every record.


>>I use "SELECT DISTINCT tip, marca, model FROM modele" to select
>>records without duplicates on the field "tip". This works ok, BUT if I
>>use "SELECT DISTINCT tip, marca, model, id FROM..." (id is
>>auto_increment and is the table's primary key) my query won't produce
>>any result. ANyone has a clue? Thank you!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux