View columns in table tree?

[expired user #4867]'s profile image [expired user #4867] posted 13 years ago in General Permalink
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.
ansgar's profile image ansgar posted 13 years ago Permalink
Columns are also listed on each "Query" tab, in the right tree box, when a table is selected.
[expired user #4867]'s profile image [expired user #4867] posted 13 years ago Permalink
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.
ansgar's profile image ansgar posted 13 years ago Permalink
Yes, very right I guess. I thought you were working in a query tab.

In that case please note that in the trigger body, typing "new." or "old." will pop up the columns of the trigger-mapped table. Probably that helps?
[expired user #4867]'s profile image [expired user #4867] posted 13 years ago Permalink
Not so much in my case--just because the triggers are used to check values in other tables to ensure the operation is allowed before proceeding. But it's good to know and I appreciate you taking the time to respond.
ansgar's profile image ansgar posted 13 years ago Permalink
What I just notice, also this works for other tables: Typing the table name and a dot - "sometable.".

Please login to leave a reply, or register at first.