Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've entered the create table statement exactly as shown in
the book (pg. 28 if you have the book) and I get an error message every
time. This is very frustrating as I can't go any further with the
),
- species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
-Original Message-
FROM: Jeff Caron
TO: [EMAIL PROTECTED]
DATE: Wed 6/13/01 10:15
SUBJECT: Newbie stumped by table error
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've entered
on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wrote:
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've entered the create table statement exactly as shown in
the book (pg. 28 if you have the book) and I get an error message every
time.
Also, I don' think -00-00 is a valid Date. You might want to use
something else as a default.
- TIM
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've entered the create table statement exactly as shown in
the book (pg. 28 if you have
Did you try taking out one of the 'last_name' field definitions?? It
looks like you have two there...
- TIM
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've entered the create table statement exactly as shown in
the book (pg. 28 if you
Tim,
I noticed that too. I only repeated it when I typed it into the email
message though, not my MySQL monitor.
Thanks,
Jeff
From: Tim [EMAIL PROTECTED]
Date: Wed, 13 Jun 2001 12:19:29 -0400 (EDT)
To: Jeff Caron [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Newbie stumped
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Newbie stumped by table error
Also, I don' think -00-00 is a valid Date. You might want to use
something else as a default.
- TIM
Hello-
I'm just beginning to teach myself MySQL with the help of Michael Widenius'
book MySQL. I've
You'll see exactly that error if you type the default date -00-00
*without* the quotes. If you included the quotes, then something is
quite odd indeed. This is such a basic statement in the book that
you can be sure any error would have been reported by now.
What version of MySQL are you