#520 SUM and AVG in browse table-view
i think to people with not such a great skill in SQL
there should be offered more of the great
functionlalities that SQL-Queries have.
a dropdownbox underneath the table in the "browse" view
with all fields of that table and a second option if
you want to see SUM(), COUNT(), MIN(), MAX() or AVG()
of all fields with a numeric type grouped by the field
selected in the first dropdownbox - if you press that
button, you will be led to the page with a query like this:
SELECT field_1, SUM(field_2), SUM(field_3), SUM(field_4)
FROM `table_x`GROUP BY field_1
more functionality could be offered for example
date-sort Queries or date select funcions like
FROM_UNIXTIME() or DATE_FORMAT() (see:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
)
Discussion
Logged In: YES
user_id=334647
i coded the needed changes.
you can download them here
Logged In: YES
user_id=334647
attached are
libraries\display_tbl.lib.php
and
sql.php
i used the scripts from the 2.6.0-alpha2 release
Logged In: YES
user_id=334647
there was an error in sql.php
Logged In: YES
user_id=334647
what do you think about this new feature?
maybe the place to put it should be the Query window instead.
if you think it is useful i will continue developing the new
feature
Logged In: YES
user_id=192186
Can you provide rather diffs than modified files? It is
easier to rewiew.
Anyway I'm not sure whether this would be enough used to add
more stuff to browse page.
Logged In: YES
user_id=334647
with totalcommander (http://www.ghisler.com/ ) you can
easily see the diffs of two files (files->Compare by content)
i think the query page is the better place to put it.
you can see a demo of my idea here but i didnt move the
selectboxes to the query-window yet:
http://hirnbrand/test/phpMyAdmin-2.6.0-alpha2/index.php?lang=en-utf-8&server=1&hash=976cb9d378c8e2d49f24eaa74f3dbf3d1085077930&lightm_db=test&createlink=1
Logged In: YES
user_id=192186
There is no problem to create diff, but the code changes, so
I (and other devs also) do not have version you used for
modification, so it is needed to get that older version and
then make diffs.
The url doesn't seem to be correct, probably bad hostname.
Logged In: YES
user_id=334647
ok, i add the original files, i used here
and the url has to be:
http://www.hirnbrand.de/test/phpMyAdmin-2.6.0-alpha2/index.php?lang=en-u
tf-8&server=1&hash=976cb9d378c8e2d49f24eaa74f3dbf3d1085077930&lig
htm_db=test&createlink=1
:)
Logged In: YES
user_id=334647
so what do you think about this feature?
i could add it to the current cvs-version.
i think it should be in the Query Window better than in the
browse window.
Feature declined https://wiki.phpmyadmin.net/pma/2015-06_Meeting