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
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.
Some of these are covered by the Visual Query Builder and IMO, improvements should go there rather than cluttering the SQL text area
Agreed.