MySQL Workbench Chinese tutorial

MySQL Workbench is a visual database design tool recently released by MySQL AB. This tool is a dedicated tool for designing MySQL databases.

The physical data model you created in MySQL Workbench is called. A physical data model is a data model for a specific RDBMS product. The model in this article will have some unique MySQL specifications. We can use it to generate (forward-engineer) database objects. In addition to tables and columns (fields), we can also contain views.

MySQL Workbench details: click here
MySQL Workbench: click here

For more information, see MySQL Workbench "Error Code: 1175 ".

MySQL Workbench has many functions and features. This article, written by Djoni Darmawikarta, shows some of them through an example. We will create a physical data model for an order system, where the order system can be a sales order or an order, and use forward-engineer (forward engine) generate our model into a MySQL database. In our example, the physical model created using MySQL Workbench looks like this: create ORDER Schema first let's create a solution to save the physical model of the ORDER. Click the + button (marked in red) to change the default name of the new solution to "order. Note that when you type a solution name, the label name on Physical Schemata also changes-this is a good feature. The Order Scheme is added to the Catalog (Red circled in the figure ). Close the schema window after renaming the solution. To create an ORDER table, we now create three tables in the ORDER model: ORDER table and its two subtables SALES_ORDER and PURCHASE_ORDER. First, make sure that you have selected the label of the ORDER scheme, so that the table we created will be included in this scheme. The table we want to create is displayed as an EER chart (EER = Enhanced Entity Relationship ). Therefore, double-click Add digoal. Click the Table icon, move the mouse to the EER digoal area, and click the cursor at the position where you want to place the first Table. For the other two tables, repeat the preceding operation. You can drag a table to move its position. In the next step, we need to perform some operations on table 1. These operations are completed through the table editor of Workbench. To open the Table Editor, right-click table1 and select the Edit Table menu. Enter the table name ORDER in table 1. Next, add columns (fields ). Select the Columns label. Change the column name (field name) idORDER to ORDER_NO. Select the Data Type INT in the drop-down list box. We want the value of the ORDER_NO column to be automatically controlled by the MySQL database. Therefore, we select the AI column (Auto Increment-Auto Increment ).

1 2 3 Next Page