Don't know if you MYSQL users know about the MySQL Control Center application provided by MySQL, but it is pretty cool.
PROS:
1) Sleek User Interface (graphically shows PRI keys and I believe you can map relations (FK), but I haven't figured that out yet, also graphically shows indices).
2) Some queries download faster than web browser and telnet/ssh. Some SQL statements execute quite quickly like DELETE and INSERT.
3) Multi-window display helps to show historical SQL statements and current actions.
CONS:
1) System crashes with "large" queries. Kind of bad that I tried a simple SELECT of one of my "large" tables with 2,500 rows/records and my computer crashed. Yea, I quoted "large" because is is relative between my tables, not to the maximum number of rows that can be stored in MySQL tables. Your mileage may vary as I have really old computer at home - (64 MG/Ram, Pentium I, 32-bit Virtual Memory, Windows 95b).
2) Not very user-friendly in terms of SQL beginners. You have to know SQL in order to operate the application via the SQL pane.
3) Compared to other products like MS SQL Server Enterprise Manager, some of the screens are difficult to interpret (related to #2).
You can download MyCC at the http://www.mysql.com web site.
========================================
Buh Bye!
Cheers,
Me
PROS:
1) Sleek User Interface (graphically shows PRI keys and I believe you can map relations (FK), but I haven't figured that out yet, also graphically shows indices).
2) Some queries download faster than web browser and telnet/ssh. Some SQL statements execute quite quickly like DELETE and INSERT.
3) Multi-window display helps to show historical SQL statements and current actions.
CONS:
1) System crashes with "large" queries. Kind of bad that I tried a simple SELECT of one of my "large" tables with 2,500 rows/records and my computer crashed. Yea, I quoted "large" because is is relative between my tables, not to the maximum number of rows that can be stored in MySQL tables. Your mileage may vary as I have really old computer at home - (64 MG/Ram, Pentium I, 32-bit Virtual Memory, Windows 95b).
2) Not very user-friendly in terms of SQL beginners. You have to know SQL in order to operate the application via the SQL pane.
3) Compared to other products like MS SQL Server Enterprise Manager, some of the screens are difficult to interpret (related to #2).
You can download MyCC at the http://www.mysql.com web site.
========================================
Buh Bye!
Cheers,
Me
Brief Review of MySQL Control Center (MyCC)