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),
-> 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 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
---------------------------------------------------------------------
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
