![]() |
|
|
#1 |
|
Junior Member
Join Date: Sep 2005
Posts: 1
|
Layout Questions
Hi,
I have been trying to decide which program to purchase. I am trying to decide between SQLyog, Navicat, and EMS Manager. There are things that I like about each one. I really like Navicat but something that I find anyoing is that I can't look at a tables structure when I am working on a sql query. Is there any way to setup the layout so that I can click on the tables on the left side and have the structure show up in the top main window while I make my query in the bottom.? If I open a window and don't dock it they disapear as soon as I click on the main window Thanks for any help Scandog Also If anyone has any comments on any of these programs I would love to here them. |
|
|
|
|
|
#2 |
|
Junior Member
Join Date: Dec 2005
Posts: 2
|
Re: Layout Questions
This is exactly the question I was going to post. I would like to have my table list on the left-hand side, my query area (docked to main) in the lower area where it is, and the upper portion displaying the fields of whichever table I have selected in the left-side list. As it is, it displays the full table list again when I click a table from the list, which is redundant. When writing a query from scratch, it is helpful (I would say necessary) to be able to easily view the table list without running a lot of "desc"s. I find the table-hint function to be insufficient.
The other features I was hoping to find with Navicat (I am in trial vers now, looking to buy) are in my current client, MySQLCC, and include: --Autocomplete from a keystroke, shows matches from partially type information --Table and field recognition, which changes the color for these entries based on the actual db content --Parentheses highlighting, which highlights the area of a particular start/stop parenthesis. Particularly useful for complex calculations when being off by 1 or 2 parentheses signs will kill your query. Does anyone know if any of these are available, or will be available in the near future? |
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| InnoDB , and replication Questions - newbie | CheesBagel | General | 1 | 11-09-2004 10:32 AM |
| InnoDB , and replication Questions | CheesBagel | Database Design | 0 | 11-02-2004 09:03 AM |
| 1.7 MySQL Information Sources | Administrator | Documentation | 8 | 06-08-2004 02:58 AM |