MySqlTalk.com  

Go Back   MySqlTalk.com > Navicat - MySQL management tool > Navicat Support
User Name
Password
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
Thread Tools Search this Thread
Old 09-18-2005, 07:13 PM   #1
scandog
Junior Member
 
Join Date: Sep 2005
Posts: 1 scandog is on a distinguished road
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.
scandog is offline   Fork this post Reply With Quote
Old 12-05-2005, 02:14 PM   #2
toastedkatz
Junior Member
 
Join Date: Dec 2005
Posts: 2 toastedkatz is on a distinguished road
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?
toastedkatz is offline   Fork this post Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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



All times are GMT -4. The time now is 01:32 PM.



Powered by: vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
Google
  Web http://www.mysqltalk.com
DISCLAIMERS:
1. We have no commercial interest in this site.
Banner Ads and Subscriptions will only be used to help pay for hosting and maintenance costs.
2. MySQLTalk.com is NOT affiliated with MySQL AB in any way.
3. MySQLTalk.com is NOT endorsed by MySQL AB in any way.
4. Please do not post any content that is harmful to MySQL or MySQL AB, meaning no misleading or obsolete information will be tolerated.
Well-founded constructive criticism meant to help the community is permitted.
5. This website is founded with the goal of improving the MySQL community.
We not only tolerate newbies, we encourage them.
Please do not ask newbies to "read the manual".