数据库问题最后两行代码报错1065
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)
查询:ALTER TABLE Student ADD CONSTRAINT fkl_student FOREIGN KEY (campus_id) REFERENCES campus (campus_id) ALTER TABLE `Stud。
错误代码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE Student ADD CONSTRAINT fk2_student FOREIGN KEY (`trainning_site_' at line 2
解决这个问题