Go through http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html
This is a good starting point.
Look this over and you will see your error ;
Use a CREATE TABLE statement to specify the layout of your table:
mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-
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