Menu

#757 dropdown for special SQL like SUM,AVG and GROUP BY

Needs_decision
wont-fix
nobody
None
Normal
2015-06-24
2005-07-30
No

there could be a dropdown box, next to the
sql/querz/textarea, whith important sql/commands and
their descriptions, like SUM, AVG, CONCAT,
date-conversions like FROM_UNIXTIME and many more

also the GROUP BY functionality should be acessible in pma

Discussion

  • BarryHunter

    BarryHunter - 2005-09-07

    Logged In: YES
    user_id=1224273

    I would very much like to second this request!

    Also similar would be a quick way to run

    SELECT completed, count( * )
    FROM `Messages`
    GROUP BY `completed`

    type queries, which would be REALLY useful. this wouldnt be
    approriate for many column types, but would be nice for
    enum's espically, or tinyint's etc. Easiest place would be
    to add it to the as a new icon/column on the structure page.

     
  • Madhura Jayaratne

    Some of these are covered by the Visual Query Builder and IMO, improvements should go there rather than cluttering the SQL text area

     
    • Marc Delisle

      Marc Delisle - 2015-06-24

      Agreed.

       
  • Marc Delisle

    Marc Delisle - 2015-06-24
    • status: open --> wont-fix
    • Group: --> Needs_decision