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
(EDT)
> To: Jeff Caron <[EMAIL 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
>
>
TED]>
> Subject: Re: Newbie stumped by table error
>
>
> 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
w and love.
--
Barry C. Hawkins
Systems Consultant, MCSE 4.0
[EMAIL PROTECTED]
-Original Message-
From: Jeff Caron [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:49 PM
To: Barry C. Hawkins; [EMAIL PROTECTED]
Subject: Re: Newbie stumped by table error
Thanks, Barry!
I en
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
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 y
Jeff
> From: "Barry C. Hawkins" <[EMAIL PROTECTED]>
> Date: Wed, 13 Jun 2001 12:28:30 -0400
> To: Jeff Caron <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> Subject: Re: Newbie stumped by table error
>
> on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wro
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
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),
->
