Does something like SQL Server Management Studio exist for MySQL?

[The_Fire]

Ok, first of my chest: I have recently started my course on ASP.Net and SQL with C# (not the ones I had asked about, but this one is multumuch better ).
15 weeks in total web programming nirvana (ok 4 or 5 of those are reps and final projects, but still).

What I want to know: WHY WEREN'T I TOLD ABOUT SQL SERVER MANAGEMENT STUDIO EARLIER?!!!! seriously, this tool rocks! no longer having to create joins manually.......pure heaven.

What I want to know is, if there's something like it for MySql. Yes, I'll even pay.

I'm particular fond of the entire database diagram section where you can set up inter table references etc. and the views part isn't to shabby either.

Anyone?

 

[icerat]

I use NaviCat. Not up to Management Studio, but better than the alternatives I've tried.

 

[Unabogie]

I use NaviCat. Not up to Management Studio, but better than the alternatives I've tried.

Although I think there's some utility in learning about joins by hand. Especially since setting up a proper relational db takes some strategizing and doing it wrong can wreck a website with bad performance.

 

[jmontecillo01]

MySql WorkBench

Got it under Mac and ubuntu. Don't know about windows.

 

[grmcdorman]

MySql WorkBench

Got it under Mac and ubuntu. Don't know about windows.

It's Java. Cross-platform.

 

[Wudang]

Slight digression : these days I use Spring notations etc in the "Vietnam war" that is ORM but I still really recommend Joe Celko's "SQL for smarties" for understanding how SQL works.

 

[varwoche]

What I want to know: WHY WEREN'T I TOLD ABOUT SQL SERVER MANAGEMENT STUDIO EARLIER?!!!! seriously, this tool rocks! no longer having to create joins manually.......pure heaven.

Hmm. I spend a large portion of my professional life working inside SSMS and I'm unaware of how not to create joins manually. (Nor am I aware of why I would want to automate joins.)

 

[jmontecillo01]

It's Java. Cross-platform.

I am not quite sure if we are talking about the same product. I downloaded the mac version which is a .dmg file. In ubuntu, its a .deb file.

This is the site I got it from.

http://www.mysql.com/downloads/workbench/

 

[Dessi]

I use NaviCat. Not up to Management Studio, but better than the alternatives I've tried.

Will second this. Used it for a MySQL project I was on, seemed to work well, and would also show the output of EXPLAIN.

 

[Maus]

Workbench.

 

[grmcdorman]

I am not quite sure if we are talking about the same product. I downloaded the mac version which is a .dmg file. In ubuntu, its a .deb file.

This is the site I got it from.

http://www.mysql.com/downloads/workbench/

Ah. That is indeed a different thing; there is a Java SQL Workbench: http://www.sql-workbench.net/

Supports a wide variety of SQL implementations (actually, anything Java JDBC supports), including all of the major ones.

It's the first hit for 'sqlworkbench' on teh Googles, by the way.

 

[varwoche]

What I want to know: WHY WEREN'T I TOLD ABOUT SQL SERVER MANAGEMENT STUDIO EARLIER?!!!! seriously, this tool rocks! no longer having to create joins manually.......pure heaven.

Hmm. I spend a large portion of my professional life working inside SSMS and I'm unaware of how not to create joins manually. (Nor am I aware of why I would want to automate joins.)

Maybe you're referring to the UI that constructs foreign key constraints?

 

[The_Fire]

Maybe you're referring to the UI that constructs foreign key constraints?

*pops head in from EDM homework*

Thats the one. I think.