List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:August 30 2000 11:06pm
Subject:Re: creating table
View as plain text  
At 3:02 PM -0400 8/30/00, Andrew wrote:
>I'm trying to create this table:
>
>CREATE TABLE Build_Feature_Detail (
>
>Build_Tag_No VARCHAR(20) NOT NULL,
>
>Feature_No MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
>
>Module_Code MEDIUMINT(8) NOT NULL,
>
>Feature_Description TEXT NOT NULL,
>
>Feature_Type_Code MEDIUMINT(8) NOT NULL,
>
>Expected_Behavior TEXT NOT NULL,
>
>Default CHAR(50),
>
>Value_Range CHAR(50),
>
>Verified ENUM('yes','no') NOT NULL,
>
>Verified_Date DATE NOT NULL,
>
>Developer_Code MEDIUMINT(8) NOT NULL,
>
>Developed_Date DATE NOT NULL,
>
>Patch_no VARCHAR(20) NOT NULL,
>
>PRIMARY KEY (Feature_No),
>
>KEY (Build_Tag_No,Patch_No),
>
>KEY (Module_Code,Feature_Type_Code,Developer_Code),
>
>KEY (Verified),
>
>KEY (Verified_Date)
>
>);
>
>
>
>I'm getting error 1064: You have an error in your SQL syntax near 
>'Default CHAR(50),
>
>Value_Range CHAR(50),
>
>That the error I'm getting, can anyone tell me where my syntax error is?
>


See:

http://www.mysql.com/documentation/mysql/commented/manual.php?section= 
Reserved_words

You'll have to change the name of your column.

-steve

+--- "They've got a cherry pie there, that'll kill ya" ------------------+
| Steve Edberg                           University of California, Davis |
| sbedberg@stripped                               Computer Consultant |
| http://aesric.ucdavis.edu/                  http://pgfsun.ucdavis.edu/ |
+-------------------------------------- FBI Special Agent Dale Cooper ---+
Thread
creating tableAndrew30 Aug
  • Re: creating tableNazareno30 Aug
  • Re: creating tableSteve Edberg31 Aug