Tim,
I took out the dashes as another person suggested and that made it work. I
typed in "0000-00-00" because that is what it says to enter in my MySQL book
(by Michael Widenius).
Thanks,
Jeff
> From: Tim <[EMAIL PROTECTED]>
> Date: Wed, 13 Jun 2001 12:20:49 -0400 (EDT)
> To: Jeff Caron <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: Re: Newbie stumped by table error
>
>
> Also, I don' think "0000-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 the book) and I get an error message every
>> time. This is very frustrating as I can't go any further with the tutorial
>> without creating all the tables first. Could someone on this list please
>> help me so I can correctly create this table?
>>
>> Incidentally, I checked the corrections document on the book publisher's web
>> site and there were no corrections for this page. This makes me even more
>> stumped...
>>
>> Here's the statement I submitted:
>>
>> CREATE TABLE member
>> (
>> last_name VARCHAR(20) NOT NULL,
>> last_name VARCHAR(20) NOT NULL,
>> suffix VARCHAR(5) NULL,
>> expiration DATE NULL DEFAULT "0000-00-00",
>> email VARCHAR(100) NULL,
>> street VARCHAR(50) NULL,
>> city VARCHAR(50) NULL,
>> state VARCHAR(2) NULL,
>> zip VARCHAR(10) NULL,
>> phone VARCHAR(20) NULL,
>> interests VARCHAR(255) NULL
>> )
>>
>> Here's the error message I keep getting:
>>
>> ERROR 1064 at line 1: You have an error in your SQL syntax near '-00-00,
>> email VARCHAR(100) NULL,
>> street VARCHAR(50) NULL,
>> city VARCHAR(50) NULL,' at line 6
>>
>>
>> Any help would be most appreciated.
>>
>> Jeff Caron
>>
>>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
>> <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
> --
> -TIM
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
