Depending on the version you use MySQL will see a definition of
varchar(25) as 25 bytes or 25 characters. I believe this changed from
4.1 to 5.0 respectively but I am not sure.
THis could be the root of the problem
Boyd
CONFIDENTIALITY NOTICE: This email & attached documents may conta
On 3/26/07, Anil D <[EMAIL PROTECTED]> wrote:
Varchar = 0 bytes
I don't think this is right, see below.
Charset used: UTF8
UTF8 means that some characters may be two bytes, see below.
Note: When consider even the size Varchar(m) = m+1 bytes, the size of row
has reached 35,000 bytes.
- 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
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 different in MySQL. I'm hoping someone can tell me how
to modify my script so t
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
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 STUDENTS
(studentID SMALLINT NOT NULL,
student_name char(18),
address char(20),
city char(10),
state char(2),
zip char(
12 matches
Mail list logo
