Hi Michael,
I made some changes to the sql statments to create the
ENROLLS table as follows:
CREATE TABLE ENROLLS
(courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NULL,
studentID SMALLINT NOT NULL,
grade SMALLINT)TYPE=INNODB;
PRIMARY KEY(courseID,sectionID,studentID),
INDEX(courseID),
FOREIGN KEY(courseID) REFERENCES COURSES(courseID) ON
UPDATE CASCADE ON DELETE CASCADE,
INDEX(sectionID),
FOREIGN KEY(sectionID) REFERENCES SECTIONS(sectionID)
ON UPDATE CASCADE ON DELETE CASCADE,
INDEX(studentID),
FOREIGN KEY(studentID) REFERENCES STUDENTS(studentID)
ON UPDATE CASCADE ON DELETE CASCADE)TYPE=INNODB;
The error message is as follows:
ERROR 1064 at line 38: 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
'PRIMARY KEY (countID, sectionID, studentID),
INDEX(courseID),
FOREIGN KEY(courseID' at line 1
I do not know what wrong with my syntax. Please help.
I am using MySQL version 4.1.3B.
Regards,
Maru
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
