Shulou(Shulou.com)06/01 Report--

The following is about how to export and import sql scripts into mysql after PowerDesigner modeling. The secret of the text lies in being close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from this article on how to export and import sql scripts into mysql after reading PowerDesigner modeling.

The database table structure designed by powerdesigner.

At this point, the exported .SQL script needs to be in utf-8 character set format. Otherwise, an error will be reported when importing the data. (for special needs, choose the character set according to your own database design needs.)

Look for the change format here, look for it on the Internet for a long time, and finally you have to find this on your own. There is no need to edit (or manually add) the default character set when the table is created.

Fill in the name in general, and then click OK. If you report a warning error, you can ignore it.

Log in to MySQL (mysql-h or directly log in to Navicat), select the database to which you want to pass in the data, and import the .sql file.

At this time, the character set of the database should also be changed to UTF-8 by default, otherwise, an error will still be reported.

Here I modify it using Navicat, or I can edit it manually in the database.

After right-clicking on the database, one executes SQL. Click on it and import the sql script.

After that, the table needs to be changed, and I also take advantage of Navicat. Graphical things are more convenient.

If you test it, connect to the database and insert several pieces of data with Chinese into a table.

For the above PowerDesigner modeling how to export the sql script and then import the relevant content into mysql, is there anything you don't understand? Or if you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.