List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 14 1999 9:04pm
Subject:Re: Parser buq
View as plain text  
At 10:48 AM +0200 7/14/99, leon.andonyadis@stripped wrote:
>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)


That's because LOAD DATA is a SQL statement.  You likely wouldn't be able
to create a column named CREATE or TABLE, either. :-)

-- 
Paul DuBois, paul@stripped
Thread
Parser buqleon.andonyadis14 Jul
  • Re: Parser buqJames Fidell14 Jul
  • Re: Parser buqSasha Pachev14 Jul
  • Re: Parser buqPaul DuBois15 Jul