Re: In search of a good MySQL GUI client
On Thursday, September 09, 2004 - Karam Chand said: > Probably you should put it as a bug in SQLyogs forums. I have put a bug request into the MySQL Query Browser bug track instead. I like this tool very much, it has some very nice features like the multithreaded results fetching. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Probably you should put it as a bug in SQLyogs forums. Karam --- Jose_Miguel_Pérez <[EMAIL PROTECTED]> wrote: > Karam Chand said: > > > I use SQLyog. It does allow you to create/delete > FKs > > with "ON UPDATE" criterias. > > > > Yeah, it does not allow you to create Fks in > graphical > > manner like MS SQL Server but does my purpose. One > > feature I really miss is Editing of FKs. > > Yeah, I also tried SQLyog. It's a very good > program indeed, a very nice > feature is the structure syncronization tool. > However, I said every program > I tried has problems, and SQLyog is no exception. > > I downloaded SQLyog v3.71, I'm using MySQL > 4.1.4-gamma-standard. When I > manage relationships (F10 key), the FK's not even > show up on the list... If > I now press "New.." to create a relationship, I can > fill in the blanks and > press "Create", however SQLyog didn't show the new > relationship either. I > ended up creating 5 (five) equal relationships since > SQLyog wasn't showing > them in the list. A nasty GUI bug, sure, but this > renders SQLyog unuseable > to me. > > Cheers, > Jose Miguel. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Karam Chand said: > I use SQLyog. It does allow you to create/delete FKs > with "ON UPDATE" criterias. > > Yeah, it does not allow you to create Fks in graphical > manner like MS SQL Server but does my purpose. One > feature I really miss is Editing of FKs. Yeah, I also tried SQLyog. It's a very good program indeed, a very nice feature is the structure syncronization tool. However, I said every program I tried has problems, and SQLyog is no exception. I downloaded SQLyog v3.71, I'm using MySQL 4.1.4-gamma-standard. When I manage relationships (F10 key), the FK's not even show up on the list... If I now press "New.." to create a relationship, I can fill in the blanks and press "Create", however SQLyog didn't show the new relationship either. I ended up creating 5 (five) equal relationships since SQLyog wasn't showing them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable to me. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
I use SQLyog. It does allow you to create/delete FKs with "ON UPDATE" criterias. Yeah, it does not allow you to create Fks in graphical manner like MS SQL Server but does my purpose. One feature I really miss is Editing of FKs. Karam --- Jose_Miguel_Pérez <[EMAIL PROTECTED]> wrote: > Hi All! > > Why are all MySQL GUI clients so bad with > foreign keys? Sorry to seem > annoyed, but I have used for quite some time a few > GUI clients, notably > MySQL-Front, which I were relatively confortable > with. Anyway, all GUI > clients I used (SQLyog, MySql-Front, MySQL-CC, you > name it) seemed to be > some sort of shortcut to the MySQL command line. No > problem with that, > that's what I am looking for and not some high-level > CASE tool. > > It's when looking for foreign keys and > referential integrity where these > tools fail miserably. None of them fully supports > editing / creating / > deleting foreign keys. If you are to reply to this > message, please read > again the "FULLY supports" statement. For example, > with version 1.0.7-beta > of MySQL Query Browser (Own MySQL AB tool) I'm > unable to add an "ON UPDATE" > constraint... silly, huh? This is not a strange > "Fails when lib-foo > v1.2.3.5.7 connects throu a CISCO 90238234 router in > a full moon night" > error, it's simply that the programmer (nor the > bug-testing labs) have not > tried the "On Update:" drop-down menu from the edit > table dialog. > > I know foreign keys are a relatively new area in > the MySQL field and > maybe the programmers are slowly adding support for > it, but it's quite > annoying to see monumental bugs editing and changing > foreign keys in ALL > programs I've tried. > > Please, note that this message is not intended > to flame anyone. I fully > aknowledge the effort involved creating such a tool, > I'm a programmer after > all, and some of them are in beta anyway. I would > appreciate if anyone knows > some tool which good foreign key support. > > Cheers, > Jose Miguel. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: In search of a good MySQL GUI client
Hello Jose, > Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem > annoyed, but I have used for quite some time a few GUI clients, notably > MySQL-Front, which I were relatively confortable with. Anyway, all GUI > clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be > some sort of shortcut to the MySQL command line. No problem with that, > that's what I am looking for and not some high-level CASE tool. > > It's when looking for foreign keys and referential integrity where these > tools fail miserably. None of them fully supports editing / creating / > deleting foreign keys. If you are to reply to this message, please read > again the "FULLY supports" statement. For example, with version 1.0.7-beta > of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an "ON UPDATE" > constraint... silly, huh? This is not a strange "Fails when lib-foo > v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night" > error, it's simply that the programmer (nor the bug-testing labs) have not > tried the "On Update:" drop-down menu from the edit table dialog. > > I know foreign keys are a relatively new area in the MySQL field and > maybe the programmers are slowly adding support for it, but it's quite > annoying to see monumental bugs editing and changing foreign keys in ALL > programs I've tried. > > Please, note that this message is not intended to flame anyone. I fully > aknowledge the effort involved creating such a tool, I'm a programmer after > all, and some of them are in beta anyway. I would appreciate if anyone knows > some tool which good foreign key support. Well, you still need to manually create indices - but the FKs work just fine in ... Database Workbench - www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In search of a good MySQL GUI client
Hi All! Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem annoyed, but I have used for quite some time a few GUI clients, notably MySQL-Front, which I were relatively confortable with. Anyway, all GUI clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be some sort of shortcut to the MySQL command line. No problem with that, that's what I am looking for and not some high-level CASE tool. It's when looking for foreign keys and referential integrity where these tools fail miserably. None of them fully supports editing / creating / deleting foreign keys. If you are to reply to this message, please read again the "FULLY supports" statement. For example, with version 1.0.7-beta of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an "ON UPDATE" constraint... silly, huh? This is not a strange "Fails when lib-foo v1.2.3.5.7 connects throu a CISCO 90238234 router in a full moon night" error, it's simply that the programmer (nor the bug-testing labs) have not tried the "On Update:" drop-down menu from the edit table dialog. I know foreign keys are a relatively new area in the MySQL field and maybe the programmers are slowly adding support for it, but it's quite annoying to see monumental bugs editing and changing foreign keys in ALL programs I've tried. Please, note that this message is not intended to flame anyone. I fully aknowledge the effort involved creating such a tool, I'm a programmer after all, and some of them are in beta anyway. I would appreciate if anyone knows some tool which good foreign key support. Cheers, Jose Miguel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]