Newbie stumped by table error

2001-06-13 Thread Jeff Caron
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

Re: Newbie stumped by table error

2001-06-13 Thread Jeff Caron
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

Re: Newbie stumped by table error

2001-06-13 Thread Jeff Caron
Tim, I took out the dashes as another person suggested and that made it work. I typed in -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