How to solve mysql error 1005 problem

Solution to mysql error 1005: 1. Use the "SHOW ENGINE INNODB STATUS;" command to view detailed error prompts; 2. Modify "LATEST FOREIGN KEY ERROR".

The operating environment of this article: Windows 7 system, mysql version 5.5, Dell G3 computer.

How to solve the mysql error 1005 problem?

Analysis of the solution to ERROR 1005 when creating foreign keys in MySQL:

When creating a foreign key in MySQL, an error is prompted, but only a very simple message is prompted: ERROR 1005 (HY000): Can't create table 'db_qxztc.qx_userssssnew' (errno: 150). It doesn't solve the problem at all.

To see detailed error prompts, you can use the command: (found when searching for "errno 150" in MySQL Manual)

SHOW ENGINE INNODB STATUS;     //针对用INNODB存储方式的数据库

There is a group of [LATEST FOREIGN KEY ERROR] in the information. Detailed description and resolution of the most recent error.

For example:

111211 12:49:34 Error in foreign key constraint of table db_qxztc/qx_userssssnew
:
 foreign key(`SSSSID`) references`qx_SSSS`(`SSSSID`)):
Syntax error close to:
`qx_SSSS`(`SSSSID`))

It prompts that there is a syntax error near `qx_SSSS`(`SSSSID`). You should check it carefully. The mistake I made here was between references and its parameters. , missing spaces. .

Recommended learning: "mysql video tutorial"

The above is the detailed content of How to solve mysql error 1005 problem. For more information, please follow other related articles on the PHP Chinese website!