James Fidell wrote:
>
> Quoting leon.andonyadis@stripped (leon.andonyadis@stripped):
> >
> >
> > CREATE TABLE LOADPRESSREV (
> > LOAD_PRESS_ID SMALLINT NOT NULL,
> > PRESSURE DOUBLE PRECISION,
> > LOAD SMALLINT,
> > LI_MAIN SMALLINT,
> > SI_MAIN SMALLINT,
> > LI_ALT SMALLINT,
> > SI_ALT SMALLINT,
> > STEELBELT VARCHAR(2),
> > PRLI SMALLINT NOT NULL,
> > PRORLI SMALLINT NOT NULL,
> > LAST_REV_NR SMALLINT NOT NULL,
> > ACTIVATED SMALLINT,
> > VISIBILITY SMALLINT,
> > LOAD_PRESS_REV_ID SMALLINT NOT NULL,
> > LOADPRESS_REVISION SMALLINT NOT NULL,
> > DATUM DATE,
> > SIGN CHAR(3),
> > INFO VARCHAR(40)
> > )
> >
> > this table definition does not parse, if I change LOAD SMALLINT to LOAD1
> > SMALLINT then it works.(shareware mysql in win95)
>
> "LOAD" is a reserved word ?
>
Yes, it is, so this is supposed to fail! A feature - not a bug!
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
