viso2010从mysql中导出ER图-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

viso2010从mysql中导出ER图

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:01 PM

mysqlExport

mysql connector 下载地址：http://download.csdn.net/detail/dulei294948/6430689 首先机器要安装mysql-connector-odbc插件，这样会使viso识别mysql的odbc驱动、 1.打开viso 选择软件和数据库，然后选择数据库模型图,点击确定 2.进入页面选择数据库-反向工

mysql connector 下载地址：http://download.csdn.net/detail/dulei294948/6430689

首先机器要安装mysql-connector-odbc插件，这样会使viso识别mysql的odbc驱动、

1.打开viso

选择"软件和数据库"，然后选择"数据库模型图",点击"确定"

2.进入页面

选择"数据库"->"反向工程"，这样会弹出弹出框

3.数据源中有一个"mysql"选项，这个选项，第一次打开的时候是不会出现的，需要点击新建(我这里已经建过了)

4.点击"用户数据源(只用于当前机器)'点击下一步

viso2010从mysql中导出ER图

5.点击mysql驱动，然后点击下一步

viso2010从mysql中导出ER图

6.点击完成

7.填一下基本信息

8.点击"ok"

viso2010从mysql中导出ER图

9.输入用户名和密码

10.点击下一步

viso2010从mysql中导出ER图

11.点击下一步(这里我只选了表中的主键)

viso2010从mysql中导出ER图

12.点击全选以后，点击下一步

13.点击下一步

viso2010从mysql中导出ER图

14.点击完成

viso2010从mysql中导出ER图

15.看到了吧。 ER图就可以显示出来了。

呵呵。还不错，一起进步吧

博客:http://blog.csdn.net/dsundsun

QQ:349466315

邮箱：dreamlfy@126.com

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

When should you use a composite index versus multiple single-column indexes?Apr 11, 2025 am 12:06 AM

In database optimization, indexing strategies should be selected according to query requirements: 1. When the query involves multiple columns and the order of conditions is fixed, use composite indexes; 2. When the query involves multiple columns but the order of conditions is not fixed, use multiple single-column indexes. Composite indexes are suitable for optimizing multi-column queries, while single-column indexes are suitable for single-column queries.

How to identify and optimize slow queries in MySQL? (slow query log, performance_schema)Apr 10, 2025 am 09:36 AM

To optimize MySQL slow query, slowquerylog and performance_schema need to be used: 1. Enable slowquerylog and set thresholds to record slow query; 2. Use performance_schema to analyze query execution details, find out performance bottlenecks and optimize.

MySQL and SQL: Essential Skills for DevelopersApr 10, 2025 am 09:30 AM

MySQL and SQL are essential skills for developers. 1.MySQL is an open source relational database management system, and SQL is the standard language used to manage and operate databases. 2.MySQL supports multiple storage engines through efficient data storage and retrieval functions, and SQL completes complex data operations through simple statements. 3. Examples of usage include basic queries and advanced queries, such as filtering and sorting by condition. 4. Common errors include syntax errors and performance issues, which can be optimized by checking SQL statements and using EXPLAIN commands. 5. Performance optimization techniques include using indexes, avoiding full table scanning, optimizing JOIN operations and improving code readability.

Describe MySQL asynchronous master-slave replication process.Apr 10, 2025 am 09:30 AM

MySQL asynchronous master-slave replication enables data synchronization through binlog, improving read performance and high availability. 1) The master server record changes to binlog; 2) The slave server reads binlog through I/O threads; 3) The server SQL thread applies binlog to synchronize data.

MySQL: Simple Concepts for Easy LearningApr 10, 2025 am 09:29 AM

MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

MySQL: A User-Friendly Introduction to DatabasesApr 10, 2025 am 09:27 AM

The installation and basic operations of MySQL include: 1. Download and install MySQL, set the root user password; 2. Use SQL commands to create databases and tables, such as CREATEDATABASE and CREATETABLE; 3. Execute CRUD operations, use INSERT, SELECT, UPDATE, DELETE commands; 4. Create indexes and stored procedures to optimize performance and implement complex logic. With these steps, you can build and manage MySQL databases from scratch.

How does the InnoDB Buffer Pool work and why is it crucial for performance?Apr 09, 2025 am 12:12 AM

InnoDBBufferPool improves the performance of MySQL databases by loading data and index pages into memory. 1) The data page is loaded into the BufferPool to reduce disk I/O. 2) Dirty pages are marked and refreshed to disk regularly. 3) LRU algorithm management data page elimination. 4) The read-out mechanism loads the possible data pages in advance.

MySQL: The Ease of Data Management for BeginnersApr 09, 2025 am 12:07 AM

MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.

See all articles