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!