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 ---+
