#53 Request: DISTINCT

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

DINSTINCT without COUNT, in "selector" mode.

Discussion

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous - 2010-04-29
    • summary: feature: DISTINCT --> Request: DISTINCT
     
  • 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.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks