PowerDesigner generates data structural diagrams and corresponding SQL export methods

1. Download powerDesigner

  The link address is http://soft.onlinedown.net/soft/577763.htm

2. Open the software, file -> new project, create a new project; then create a new entity to build a table;

3. Right-click entity -> new directly, and the corresponding pop-up box will appear, as shown in the figure:

  < img alt="Share a picture" src="/wp-content/uploads/images/database/power-designer/1626816353032.png" width="563" height="385" >

You can create the corresponding table name and column attributes, just confirm it, Note:

   The self-increasing column can click on this row, and it will appear In the pop-up box, check this, as shown in the figure: Share a picture

   It is worth noting that directly saves and generates a .cdm file, The built physical model will generate a .pdm file, the method of generating a pdm file:

  share picture

Select this.

4. Open the .pdm file, you will find that the menu bar has an extra database item:

 share picture

   Click database -> generate database, select the table to export sql, and click OK.

  share picture

How about, is it very simple~~~

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 839 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.