PowerDesigner creates a database table and exports SQL

I recently accepted a new project. The project structure uses jdbc to connect to the database, and the database uses orcal. I used to use hibernate to automatically generate tables. Now I have to design the watch, the project time is still tight, I really find it troublesome.

There is no way to [the soldiers come to cover, the water comes to cover].

1. Install PowerDesigner 15.1 Chinese cracked version.

2. Open PowerDesigner, Create your physical model. As shown below.

< br>

3.click here to confirm. Because my database is oracle, the DBMS should choose oracle11g accordingly. As shown in the figure below.

< br>

4.Next in Just create a table as shown in the figure below on the icon you created.



5.Now you can write your table here.


< /span>

6. Create a sequence for the primary key of the table, as shown below:

< span style="color:rgb(51,51,51); font-family:arial, Song Ti, sans-serif; font-size:14px; li ne-height:28px">

< img src="/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png" alt="" d="14360077" s="3c6_fb9" t="jpg">
< /span>


Export sql statement:

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 = 782 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.