MySQL Workbench How to export an existing database to an ER model

Source: Internet
Author: User

Workbench's expertise is to create a table structure, and then in the structure diagram, the circle point Point, it is easy to use a visual way to build the database, and then import into the database server, this method is efficient. But sometimes we have a need, without building a table structure model, but using other database software built database, and we also want to use Workbench table structure model in the above modification, at this time, how the existing database exported to the model table structure is the focus!

Can do this:











How do I import a database?

There are a lot of people can not find the upgraded workbench in the browsing data function, think it is not, is wrong, is

Here is the write SQL statement


Usage when importing data



What if you want to modify a field after you finish building the table? See figure


Alternative import: said it alternative import is because at that time based on the original export SQL statements, generally exported there are two, 1 directly exported the database name, and then do not have to create a database directly into the SQL file immediately; 2 exports only data, no database name is exported. This kind of alternative refers to this situation. See
One of the keys is very discreet, such as
You know the primary key is automatically added index, but is not the primary key to do, of course, can also add, see
Click Index in the table to see the manual index, such as if the field to set a default value, such as
Here is a bit of a different kind of usage, that is, the enumeration type, the general just beginners seldom use it

How to view the relationship of the table, this feature is probably also Workbench's specialty (why many PHP programmers like to use it for reasons)

To increase the association of tables and tables, it is important to note that the relationship in the database is the most difficult to design, and Workbench has a unique tool in this area, instead of manual tedious work, with tools to create a relationship with a drag. Note that when an association is established, an associated field is added to the first table, and if you suspect that the field is too long you can change it, and this field simulates manually increasing the index automatically plus its index. This can be seen by clicking on the field after the table is built to see its properties. It's a great feature, huh!
A function that can improve productivity

MySQL Workbench How to export an existing database to an ER model

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.