MySQL Workbench,专为MySQL设计的数据库建模工具
来源:http://www.mrven.com/?p=283 MySQL Workbench 是一款专为MySQL设计的ER/数据库建模工具。它是著名的数据库设计工具DBDesigner4的继任者。你可以用MySQL Workbench设计和创建新的数据库图示,建立数据库文档,以及进行复杂的MySQL 迁移。 主要功能 MyS
来源:http://www.mrven.com/?p=283
MySQL Workbench 是一款专为MySQL设计的ER/数据库建模工具。它是著名的数据库设计工具DBDesigner4 的继任者。你可以用MySQL Workbench设计和创建新的数据库图示,建立数据库文档,以及进行复杂的MySQL 迁移。
主要功能
MySQL Workbench的主要功能包括:
- 基于Cairo 的图形渲染,可以将内容输出到OpenGL、Win32、X11、Quartz、PostScript、PDF等多种目标上
- 可视化的表、视图、存储进程/函数和外键
- 实现数据库到SQL脚本的逆向工程
- 数据库/模型的同步
- 导出SQL创建的脚本
- 导入DBDesigner4的模型
- 支持MySQL5的特性
- 可选的图示记号
软件截图
跨平台
MySQL Workbench目前只推出了Windows版,不过未来将推出Linux和OS X版。目前,除了一个已经GA的 Windows版外,Linux版也已经进入了Alpha阶段。
作为DBDesigner4计划的继任者,MySQL Workbench 5.0版本侧重于基本功能的实现。MySQL Workbench 5.0正式发布后,开发组仍然会在bug修复、渲染效率优化、数据库文档模板和插件、模型摘要的在线存储方面进行加强。而在未来的MySQL Workbench 5.1版本中将加入对Linux和OS X平台的支持,并强化数据库查询功能,将 MySQL Workbench打造成功能完善的SQL IDE。
版本区别
MySQL Workbench有两个版本:MySQL Workbench Community Edition(又叫MySQL Workbench OSS,社区版)和MySQL Workbench Standard Edition(又叫MySQL Workbench SE,商业版)。MySQL Workbench OSS是在GPL证书下发布的开源社区版本,而MySQL Workbench SE则是按年收费的商业版本。其功能方面的差异见下表(不得不说,数据库/模型同步这一重要的功能竟然只在收费的MySQL Workbench SE中可用,而在DBDesigner4中这却是基本功能,这种“继任”方式实在让人恶心。):
MySQL Workbench 5.0 下载
要下载MySQL Workbench OSS版,可以到MySQL的官方下载点下载:http://dev.mysql.com/downloads/workbench/5.0.html
我从eMule上找到了MySQL Workbench SE版,有需要的朋友可以到这里下载:MySQL Workbench SE 下载
下载
http://drop.io/j3vtnu5/asset/mysql-workbench-se-5-0-22-win32

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



You can open phpMyAdmin through the following steps: 1. Log in to the website control panel; 2. Find and click the phpMyAdmin icon; 3. Enter MySQL credentials; 4. Click "Login".

MySQL is an open source relational database management system, mainly used to store and retrieve data quickly and reliably. Its working principle includes client requests, query resolution, execution of queries and return results. Examples of usage include creating tables, inserting and querying data, and advanced features such as JOIN operations. Common errors involve SQL syntax, data types, and permissions, and optimization suggestions include the use of indexes, optimized queries, and partitioning of tables.

Redis uses a single threaded architecture to provide high performance, simplicity, and consistency. It utilizes I/O multiplexing, event loops, non-blocking I/O, and shared memory to improve concurrency, but with limitations of concurrency limitations, single point of failure, and unsuitable for write-intensive workloads.

MySQL is chosen for its performance, reliability, ease of use, and community support. 1.MySQL provides efficient data storage and retrieval functions, supporting multiple data types and advanced query operations. 2. Adopt client-server architecture and multiple storage engines to support transaction and query optimization. 3. Easy to use, supports a variety of operating systems and programming languages. 4. Have strong community support and provide rich resources and solutions.

MySQL's position in databases and programming is very important. It is an open source relational database management system that is widely used in various application scenarios. 1) MySQL provides efficient data storage, organization and retrieval functions, supporting Web, mobile and enterprise-level systems. 2) It uses a client-server architecture, supports multiple storage engines and index optimization. 3) Basic usages include creating tables and inserting data, and advanced usages involve multi-table JOINs and complex queries. 4) Frequently asked questions such as SQL syntax errors and performance issues can be debugged through the EXPLAIN command and slow query log. 5) Performance optimization methods include rational use of indexes, optimized query and use of caches. Best practices include using transactions and PreparedStatemen

Effective monitoring of Redis databases is critical to maintaining optimal performance, identifying potential bottlenecks, and ensuring overall system reliability. Redis Exporter Service is a powerful utility designed to monitor Redis databases using Prometheus. This tutorial will guide you through the complete setup and configuration of Redis Exporter Service, ensuring you seamlessly build monitoring solutions. By studying this tutorial, you will achieve fully operational monitoring settings

The methods for viewing SQL database errors are: 1. View error messages directly; 2. Use SHOW ERRORS and SHOW WARNINGS commands; 3. Access the error log; 4. Use error codes to find the cause of the error; 5. Check the database connection and query syntax; 6. Use debugging tools.

How to solve the MySQL "Access denied for user" error: 1. Check the user's permission to connect to the database; 2. Reset the password; 3. Allow remote connections; 4. Refresh permissions; 5. Check the database server configuration (bind-address, skip-grant-tables); 6. Check the firewall rules; 7. Restart the MySQL service. Tip: Make changes after backing up the database.
