mysql - 错误1005(HY000): Can't create table 'tracker_phonetracker.location_share' (errno: -1)

Question

我在此查询中遇到了这个问题。

CREATE TABLE location_share ( 
    circle_id INT ,
    user_id INT , 
    location_sharing_id  INT , 
    PRIMARY KEY (user_id ,circle_id  ) , 
    CONSTRAINT fkcircle1 FOREIGN KEY (circle_id) REFERENCES circle(id) ON DELETE CASCADE ON UPDATE CASCADE , 
    CONSTRAINT fkuser1 FOREIGN KEY (user_id) REFERENCES user(id) ON DELETE CASCADE ON UPDATE CASCADE , 
    CONSTRAINT fksharing_policy FOREIGN KEY (location_sharing_id) REFERENCES share(id) ON DELETE CASCADE ON UPDATE CASCADE 
) ENGINE = INNODB 

Mysql 显示错误 1005:

ERROR 1005 (HY000): Can't create table 'tracker_phonetracker.location_share' (errno: -1)

此查询所依赖的其他表是:

表格:圆圈

CREATE TABLE circle (
    id INT AUTO_INCREMENT PRIMARY KEY , 
    name varchar(35)
) ENGINE=INNODB

表:用户

CREATE TABLE user (
    id INT AUTO_INCREMENT PRIMARY KEY , 
    contact_no VARCHAR(25) UNIQUE NOT NULL, 
    email VARCHAR(50) UNIQUE  NOT     NULL, 
    first_name  VARCHAR(25) NOT NULL , 
    last_name VARCHAR(25) , 
    device_id VARCHAR(250)NOT NULL  , 
    image_path VARCHAR(180) , 
    password VARCHAR(30) NOT NULL , 
    latitude VARCHAR(18) , 
    longitude VARCHAR(18) 
) ENGINE=INNODB

表:分享

CREATE TABLE share (
    id INT AUTO_INCREMENT PRIMARY KEY , 
    policy VARCHAR(6) UNIQUE NOT NULL 
)

有人可以告诉我我的查询出了什么问题吗？

谢谢!!

Answer 1

来自手册:http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html

1005 (ER_CANT_CREATE_TABLE)

Cannot create table. If the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. If the error message refers to error −1, table creation probably failed because the table includes a column name that matched the name of an internal InnoDB table.

这是由使用 user 引起的，您可以通过转义对 user 的引用来修复此问题:

 REFERENCES `user`(id)