数据库报错1064,显示格式错误
CREATE TABLE Student (
Student_id INT NOT NULL PRIMARY KEY,
Campus_id INT NOT NULL,
Training_Site_id INT NOT NULL,
Full_name VARCHAR(20) NOT NULL ,
Age id INT NOT NULL,
Email VARCHAR(20) NOT NULL,
Height id INT 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,
Location VARCHAR(20) NOT NULL
);
CREATE TABLE Training_Site(
Training_Site_id INT NOT NULL PRIMARY KEY,
Location VARCHAR(20) NOT NULL
);
报错:
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 'id INT NOT NULL,
Email VARCHAR(20) NOT NULL,
Height id INT NOT NULL
)' at line 6
帮忙解决这个问题
Age id f改为 Age_id
Height id 改为 Height_id