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
