#1208 (ok 4.4) linking from information_schema

[iinl]

it would be nice if results from querying the information_schema database would link back to the relevant pages within phpmyadmin

for example, querying table columns:

entries under 'table_schema' could link to 'db.php?db=[dbname]'
entries under 'table_name' could link to 'db.php?db=[dbname]&table=[tablename]
entries under 'column_name' could link to alter_tbl.php?db=[dbname]&table=[tablename]&field=[fieldname]

this would greatly simplify editing the same set of tables within different databases to make the sets consistent.

[Yian]

I can work on a patch for this. Is there some sort of a group decision being made about this feature?

[Marc Delisle]

I never thought about this but it might be interesting. While working on this, please include in your patch a FAQ entry in Documentation.html, explaining how to use this feature to make column attributes more consistent over the whole database or databases.

Maybe it would be cleaner if the user does not have to think of going via information_schema. For example, while viewing a table's structure, there could be a link "Compare column attributes" that goes over these columns in other tables (via information_schema) and produces a report of the differences (for example in size or type); but this might be a too big patch for someone preparing for GSoC.

[Michal Čihař]

I think best way to do such think is to use existing transformations framework as outlined in RFE#1327651