Is it possible to have the columns for a table listed in the tree of tables?
This is something MySQL Workbench and SQLyog does and is handy when you're working on a table or trigger and need to quickly see the column for a table.
OR perhaps theirs a good alternative? Currently I run a second instance so I can view the table structures as I'm writing a trigger. But it becomes awkward to switch between the two windows.
View columns in table tree?
The catch with that is that selecting a table will abort my trigger editing. So I can't view the columns for a table whilst editing a trigger at the same time.
I can switch to the query tab and run SHOW columns for the table I'm interested it, but it's not very convenient.
I can switch to the query tab and run SHOW columns for the table I'm interested it, but it's not very convenient.
Please login to leave a reply, or register at first.