A powerful management tool for MySQL with similar features to SQL Server Management studio

mysql sql-server database admin mysql-management
Chris Barry picture Chris Barry · Nov 13, 2008 · Viewed 39.1k times · Source

I am currently working with a developer who is experienced at Ms-SQL, but not much at MySQL. He has been cursing MySQL for having Bugs, and also being far harder to use.

Is is because his experience has been so good with Management studio. It seems to me that his problems are with using phpMyAdmin.

For example, he cites not being able to cross join and compare between tables of different structures using MySQL. Is the problem actually our choice of management tool, or does MySQL have these flaws that my developer thinks. I hope not, as I have just been blown away how fast doing various data management tasks have been in Studio Manager.

Answer

Saiyine picture Saiyine · Nov 13, 2008

You should really check SQLYog. It's great, and has a community version.

enter image description here

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
Storing JSON in database vs. having a new column for each key

I am implementing the following model for storing user related data in my table - I have 2 columns - uid (primary key) and a meta column which stores other data about the user in JSON format. uid | meta -------------------------------------------------- 1 | {name:[…

Read More
Differences between Database and Schema using different databases?

What are the differences in database terminology between MS SQL and MySQL? Can a MySQL instance have more than one database? It appears that it can only create different schemas. However, the SQL command is create database. In MS SQL, …

Read More