First use of MySQL and PowerDesigner

Download and install MYSQL:

Download and Installation Guide:

http://jingyan.baidu.com/article/597035521d5de28fc00740e6.html  

Website:

http://dev.mysql.com/downloads/file.php?id=454674

mysql cmd mysql navicat mysql

In today's database, I have a lot of problems, the first is to use the conceptual model (CDM) rather than the physical modelwhen architecting the database in powerdesigner (PDM ), causing me to be unable to set the foreign key (only the foreign key is set in the physical model).

Then I came across another problem: when I built a table in a physical model, I reversed the name and code Properties, resulting in a lot of rework of the table entries. In the build table of the physical model,code is the name used when the database code is generated. The name is just a note, something like a comment that cannot be reversed when set.

When I set up these table entries and exported the SQL file ready to import the mysql database, I ran into a problem with my table's name in Chinese, and when I generated the database language, PowerDesigner automatically adds quotation marks (""), causing the database to generate errors, so the name of the table entry does not appear in Chinese and white space, otherwise it will cause an error.

The next encounter is a difficult problem today, I set up a foreign key relationship in the table, the primary key name of the main table is changed to the same name as the foreign key from the table, resulting in the database generated an error, because when the primary table primary key and the foreign key name from the table is consistent, Causes the table to be created after the primary table has an entity join, which prevents the database from being built. Thus, I resolved this problem by changing the primary key of all primary tables back to the name of ID in powerdesigner .

The last thing I met was a little problem, like the one I set up in PowerDesigner, the data type of the item in MYSQL does not exist and is replaced with other data. Or use the MYSQL keyword in the name of the form item , which causes the program to execute an error, these problems can not be committed as long as the attention.

In short today is the first time to use the MYSQL tool, with PowerDesigner in the generation of database is indeed powerful, but also very convenient, but its use of proficiency or need to strengthen.

First use of MySQL and PowerDesigner