- Original Message -
From: <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Monday, January 16, 2006 10:54 AM
Subject: Re: InnoDB table creation sequence
"Rhino" <[EMAIL PROTECTED]> wrote on 01/16/2006 10:30:33
"Rhino" <[EMAIL PROTECTED]> wrote on 01/16/2006 10:30:33 AM:
> Can anyone help me with an InnoDB problem?
>
> I am trying to create a sequence of related tables using InnoDB but I'm
not
> having a lot of luck. The script I'm running would work fine in DB2 but
the
> rules are obviously differe
I am sorry. I did not remove TYPE=INNODB in the middle
of the statment. You are right. I am now getting a
different error message;
ERROR 1005 at line 33: Can't creat table
'.\enrollment1\enrolls.frm' (errno: 150)
All the tables except enrolls is created. What am I
doing wrong again?
Regards.
Ma
Mulugeta Maru wrote:
--- Michael Stassen <[EMAIL PROTECTED]> wrote:
Mulugeta Maru wrote:
Hi Michael,
I made some changes to the sql statments to create the
ENROLLS table as follows:
** Did you read this part? **
CREATE TABLE ENROLLS
(
courseID SMALLINT NOT NULL,
sectionID SMALLINT NOT NU
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
>
> Mulugeta Maru wrote:
>
> > 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,
> >
Mulugeta Maru wrote:
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;
^
You made
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
Mulugeta Maru wrote:
I was able to create all the tables below except
ENROLLS. Can anyone please help me what is wrong in my
syntax in the section that faild to create the ENROLLS
table.
CREATE TABLE ENROLLS
(
enrollmentID INT NOT NULL AUTO_INCREMENT,
courseID SMALLINT NOT NULL,
sectionID SM
