PowerDesigner creates an index

http://www.qeefee.com/article/ws00000400

http://blog.csdn.net/imlmy/article/details/8082383

Export into sql statement:

First select the database to be converted into a physical model in tools->physical data Model->, and then select database->Generate Database to generate sql statement

When importing Navicat

http://jingyan.baidu.com/article/a65957f4976aad24e67f9b9b.html

To talk about the previous example

drop table if exists key performance evaluation agreement;

drop index Index_1 on department performance index;

drop table if exists department performance index;

drop table if exists performance indicators of the group company;

If these are removed, the table can be run and generated

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