CREATE TABLE GENDER
(
SEX_CODE varchar(5),
PRIMARY KEY (SEX_CODE)
)
CREATE TABLE DEPARTMENT
(
DEPT_ID varchar(15),
DEPT_NAME varchar(50),
PRIMARY KEY (DEPT_ID,DEPT_NAME)
)
CREATE TABLE STUDENTS
(
ST_ID varchar(15),
NAME varchar(30),
AGE int,
SEX_CODE varchar(5),
ADDR varchar(100),
MAJOR_ID varchar(15),
MINOR_ID varchar(15),
PRIMARY KEY (ST_ID),
FOREIGN KEY (MAJOR_ID) REFERENCES DEPARTMENT(DEPT_ID),
FOREIGN KEY (MINOR_ID) REFERENCES DEPARTMENT(DEPT_ID),
FOREIGN KEY (SEX_CODE) REFERENCES GENDER(SEX_CODE)
)
如果把三个TABLE分别用命令导入就可以,同时导入就有问题。。显示如下:
#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 'CREATE TABLE DEPARTMENT
(
DEPT_ID varchar(15),
DEPT_NAME varchar(50),
PRIMA' at line 7
妹纸在线等大神指教
(
SEX_CODE varchar(5),
PRIMARY KEY (SEX_CODE)
)
CREATE TABLE DEPARTMENT
(
DEPT_ID varchar(15),
DEPT_NAME varchar(50),
PRIMARY KEY (DEPT_ID,DEPT_NAME)
)
CREATE TABLE STUDENTS
(
ST_ID varchar(15),
NAME varchar(30),
AGE int,
SEX_CODE varchar(5),
ADDR varchar(100),
MAJOR_ID varchar(15),
MINOR_ID varchar(15),
PRIMARY KEY (ST_ID),
FOREIGN KEY (MAJOR_ID) REFERENCES DEPARTMENT(DEPT_ID),
FOREIGN KEY (MINOR_ID) REFERENCES DEPARTMENT(DEPT_ID),
FOREIGN KEY (SEX_CODE) REFERENCES GENDER(SEX_CODE)
)
如果把三个TABLE分别用命令导入就可以,同时导入就有问题。。显示如下:
#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 'CREATE TABLE DEPARTMENT
(
DEPT_ID varchar(15),
DEPT_NAME varchar(50),
PRIMA' at line 7
妹纸在线等大神指教