Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of mysql error 1005, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Mysql error 1005 solution: 1, use the "SHOW ENGINE INNODB STATUS;" command to view the details of the error; 2, modify "LATEST FOREIGN KEY ERROR".

This article operating environment: Windows7 system, mysql5.5 version, Dell G3 computer.

Parse the solution for ERROR 1005 when creating foreign keys in MySQL:

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

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

SHOW ENGINE INNODB STATUS; / / for databases stored in INNODB

There is a set of [LATEST FOREIGN KEY ERROR] in the message that will have a detailed description and resolution of the recent error.

Such as:

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 _ SS` (`SSID`))

It is suggested that there is a syntax error near `SSSSSS` (`SSSSID`). You should check it carefully. The mistake I made here is that there is less space between references and its parameters.

Thank you for reading this article carefully. I hope the article "how to solve the problem of mysql error 1005" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.