I think that the best approach for what i pretend will be looking directly into the information_schema database and then just look into the right table.
Something like this:
mysql> select COLUMN_NAME, DATA_TYPE from COLUMNS where TABLE_NAME = "T1";
+-------------+-----------+
| COLUMN_NAME | DATA_TYPE |
+-------------+-----------+
| a | int |
| b | int |
| x | int |
+-------------+-----------+
mysql> select COLUMN_NAME, DATA_TYPE from COLUMNS where TABLE_NAME = "T1";
+-------------+-----------+
| COLUMN_NAME | DATA_TYPE |
+-------------+-----------+
| a | int |
| b | int |
| x | int |
+-------------+-----------+
To copy to clipboard, switch view to plain text mode
This will require special privileges for the user but ... if i just grant the right privileges there will be no problem.
Bookmarks