CREATE TABLE Student (
Student_id INT NOT NULL PRIMARY KEY,
campus_id INT NOT NULL,
trainning_site_id INT NOT NULL,
full_name VARCHAR(20) NOT NULL ,
age INT NOT NULL,
email VARCHAR(50) NOT NULL
);
CREATE TABLE car(
rego_number VARCHAR(20) NOT NULL PRIMARY KEY,
owner_id INT NOT NULL,
owner_name VARCHAR(20) NOT NULL,
CONSTRAINT fk1_car FOREIGN KEY (owner_id) REFERENCES student (student_id)
);
CREATE TABLE campus (
campus_id INT NOT NULL PRIMARY KEY,
campus_location VARCHAR(30) NOT NULL
);
CREATE TABLE trainning_site(
trainning_site_id INT NOT NULL PRIMARY KEY,
trainning_site_location VARCHAR(30) NOT NULL
);
ALTER TABLE Student ADD CONSTRAINT fkl_student FOREIGN KEY (campus_id) REFERENCES campus (campus_id);
ALTER TABLE Student ADD CONSTRAINT fk2_student FOREIGN KEY (trainning_site_id) REFERENCES trainning_site(trainning_site_id);
希望能帮忙修改一下
没有错误哈。看我执行的。你可以新建一个库试一下。有可能你之前创建过,再创建就报错。需要删除之前的表
你的代码并没有任何地方错
冲突了你可以删掉原来的同名的表再试
报的什么错误,方便截一下图?