Mysql Learning Series: Error: 1005 Error errno: 105 mysql Learning Series: Error: 1005 Error errno: 105
1. SQL script:
(Red indicates the modified script)
Create database if not exists insurance;
Use insurance;
Create table if not exists person (
Driver_id varchar (10 ),
Name varchar (30 ),
Address varchar (50 ),
Primary key (driver_id)
);
Create table if not exists car (
License varchar (30 ),
Model varchar (30 ),
Year smallint,
Primary key (license)
);
Create table if not exists
Accident (
Report_number varchar (10) primary key,
Date,
Location varchar (50)
);
Create table if not exists
Owns (
Driver_id varchar (10 ),
License varchar (30 ),
Primary key (driver_id, license ),
Foreign key (driver_id) references person (driver_id ),
Foreign key (license) references car (license)
);
Create table if not exists
Xukezheng (
Driver_id varchar (10 ),
Che varchar (10 ),
Report_number varchar (10 ),
Demage_amount smallint,
Primary key (driver_id, che, report_number ),
Foreign key (driver_id) references person (driver_id ),
Foreign key (report_number) references accident (report_number)
);
2. error:
The xukezheng table cannot be created when the SQL statement is executed.
3. error cause:
In the xukezheng table, report_number is referenced as a foreign key, which is not defined as a primary key in the accident. An error occurs.
From: http://hi.baidu.com/jbm3072/item/37eb8ed62e2e9053d63aae43