PowerDesigner the SQL script after modeling and then import it into MySQL

A database table structure designed using PowerDesigner.

At this point, the exported. SQL script needs to be in the Utf-8 character set format. Otherwise, you will get an error when importing data. (For special needs, select character sets based on your database design needs)

Find a change in the format here, on the internet for a long time, and finally have to find this. There is no need to edit (manually add) the default character set when creating a table.

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9E/26/wKiom1mMBQXg9MV7AABXsqY31mM975.png "style=" float : none; "title=" Clipboard.png "alt=" Wkiom1mmbqxg9mv7aabxsqy31mm975.png "/>

Fill in the name in the general, then click OK, and you're done. If the warning is wrong, you can ignore it.

Log in to MySQL (mysql-h or direct login navicat), select the database you want to pass in the data, and import the. sql file.

This time, also will be the database character set by default also become UTF-8, otherwise, will still error.

Here I am using Navicat modified, can also be manually edited in the database.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/9E/26/wKiom1mMBQbiM535AACg_nNg4Iw257.png "style=" float : none; "title=" Clipboard2.png "alt=" Wkiom1mmbqbim535aacg_nng4iw257.png "/>

Right click on the database, there is an execution of SQL, click to import SQL script.

I also use the navicat to make changes to the table. Graphic things are easier.

To test it, connect to the database and insert several Chinese-language data into a table.

This article is from the "Vernacular" blog, please be sure to keep this source http://feature09.blog.51cto.com/12614993/1955145

PowerDesigner the SQL script after modeling and then import it into MySQL