In the reverse engineering of the MySQL database, hintana cannot generate the primary-foreign key relationship.

When using myeclipse for development and reverse engineering of hibernate, we found that the one-to-one key relationship could not be generated, the explicit database has a primary-foreign key relationship. why is reverse generation unavailable?

There is no direct answer to the decisive search, but I still find some clues. "MyISAM database engine does not support transaction processing or foreign keys." I have a look at this sentence.

Query the current MySQL Database Engine

Show engines;

Indeed, the MyISAM engine was changed to the InnoDB type.

Alter table table name type = InnoDB;

The prompt is successful. But it still does not work. Check the database engine to find the problem. In the past, MySQL did not support the InnoDB database engine.

Why is it not supported? MySQL is of the InnoDB type by default. The cause is as follows:

Previously, to test some PHPProgramA one-click installation package for phpnow is provided. This package is green. so it seems quite useful all the time. mySQL installed on the computer enables me to start it manually. so the database I have been using has become the database provided in phpnow.

Innordb is much more powerful than myiasm, but the performance of innordb is much worse than MyISAM.

It took more than 500 seconds to import a database.

In addition, do not forget to change the database data engine. Because the import is still the original data engine, you need to manually change it.

Alter table table name type = InnoDB;

This article is from nabaichuan. Please indicate the source and corresponding link when reprinting.

Permanent link to this article: http://www.bicner.com/55.html