View columns in table tree?
| User, date | Message |
|---|---|
|
Written by microUgly
2 years ago Category: General 20 posts since Fri, 16 Apr 10 |
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. |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
Columns are also listed on each "Query" tab, in the right tree box, when a table is selected. |
|
Written by microUgly
2 years ago 20 posts since Fri, 16 Apr 10 |
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. |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
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? |
|
Written by microUgly
2 years ago 20 posts since Fri, 16 Apr 10 |
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. |
|
Written by ansgar
2 years ago 3958 posts since Fri, 07 Apr 06 |
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. |