Menu

#53 Request: DISTINCT

closed-wont-fix
nobody
None
5
2010-04-29
2010-04-29
Anonymous
No

DINSTINCT without COUNT, in "selector" mode.

Discussion

  • Jakub Vrána

    Jakub Vrána - 2010-04-29
    • status: open --> closed-wont-fix
     
  • Jakub Vrána

    Jakub Vrána - 2010-04-29

    The problem with DISTINCT is that it is not a column modifier, it is the whole SELECT modifier. It is possible to execute e.g. SELECT DISTINCT CHAR_LENGTH(column). So there would have to be a new checkbox for DISTINCT which would complicate the user interface (it is not such common operation).

    When I personally want to list distinct values then I select column together with COUNT(*) which would create GROUP BY column which is basically the same as DISTINCT.

    To enable this feature, you can create your own customization: http://www.adminer.org/cs/extension/ (methods selectColumnsPrint and selectColumnsProcess).

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.