强大的 MySQL 管理工具,功能与 SQL Server Management Studio 相似

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/286755/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 12:22:58  来源:igfitidea点击:

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

mysqlsql-serverdatabaseadminmysql-management

提问by Chris Barry

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.

我目前正在与一位在 Ms-SQL 方面经验丰富但在 MySQL 方面经验不多的开发人员一起工作。他一直在诅咒 MySQL 有错误,而且它更难使用。

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

是因为他在管理工作室的经历非常好。在我看来,他的问题在于使用 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.

例如,他引用了无法使用 MySQL 在不同结构的表之间进行交叉连接和比较。问题是我们选择的管理工具,还是MySQL有我开发人员认为的这些缺陷。我希望不会,因为我刚刚对在 Studio Manager 中执行各种数据管理任务的速度感到震惊。

采纳答案by Saiyine

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

你真的应该检查SQLYog。它很棒,并且有社区版本。

enter image description here

在此处输入图片说明

回答by Galwegian

Quest Toadis good and has pay and free versions for *MySQL.

Quest Toad很好,有*MySQL 的付费和免费版本。

  • free version no longer available
  • 免费版本不再可用

回答by AngryHacker

Hate to rain on your parade of tools, but while some of the ones mentioned here are pretty cool, none of them have the mojo of SSMS.

讨厌在你的工具游行上下雨,但是虽然这里提到的一些工具很酷,但它们都没有 SSMS 的魔力。

In my MySQL work, I basically switched between SQLYog and MySQL GUI Tools, depending on what I did. SQLYog Enterprise Edition (e.g. the non-free one) also adds support for really basic schema code completion.

在我的 MySQL 工作中,我基本上在 SQLYog 和 MySQL GUI 工具之间切换,这取决于我所做的。SQLYog 企业版(例如非免费版)还增加了对真正基本模式代码完成的支持。

回答by DiGi

More tools to try: EMS SQL Management Studioor MySQL GUI Tools(now called MySQL Workbench)

更多工具可以尝试:EMS SQL Management StudioMySQL GUI 工具(现在称为MySQL Workbench

回答by Jeremiah Peschka

I would suggest Aqua Data Studio. I don't think that it has a free version, however it is pretty powerful and has a ton of great features that are similar to SQL Server Management Studio.

我会建议Aqua Data Studio。我不认为它有免费版本,但是它非常强大,并且具有大量类似于 SQL Server Management Studio 的强大功能。

回答by Hymanet

VSQL++ for MySQLis a powerful GUI database management tool for MySQL

VSQL++ for MySQL是一款强大的MySQL图形用户界面数据库管理工具