Try back ticks around it.  `DESC'

> Dear Friends.
>
> when Creating the follow table
>
> CREATE TABLE CONHEC_DBF (    CON CHAR (7) ,
>    SER CHAR (2) ,
>    NUMNF CHAR (8) ,
>    SERNF CHAR (2) ,
>    LOJA CHAR (2) ,
>    PAIDF CHAR (12) ,
>    QUANT REAL (6,0) ,
>    NOP CHAR (10) ,
>    TRAN CHAR (4) ,
>    DTC DATE,
>    DTE DATE,
>    ESPEC CHAR (10) ,
>    PESO REAL (8,2) ,
>    VALORNF REAL (12,2) ,
>    FRPESO REAL (12,2) ,
>    FREVAL REAL (12,2) ,
>    VALKILO REAL (12,2) ,
>    PERVFRE REAL (12,2) ,
>    PERTFRE REAL (12,2) ,
>    OUTROS REAL (12,2) ,
>    PREST REAL (12,2) ,
>    BCFRE REAL (12,2) ,
>    ALIICM REAL (6,2) ,
>    ICMS REAL (12,2) ,
>    TOTFRE REAL (12,2) ,
>    VALOREM REAL (12,2) ,
>    CIFFOB CHAR (1) ,
>    TIPOFAT CHAR (1) ,
>    TIPTRAN CHAR (1) ,
>    FATURA CHAR (10) ,
>    DATAFAT DATE,
>    DESC REAL (12,2) ,
>    IMPEXP CHAR (1) ,
>    SR_RECNO BIGINT (15) NOT NULL AUTO_INCREMENT ,
>    SR_DELETED CHAR (1)  NOT NULL
> , PRIMARY KEY (SR_RECNO)
>  ) Type=InnoDb
>
> I got an Erro when defining Column DESC(same error even if DESC is between
> "")
>
> So how can i Create this Column, or how to resolve this problem
> mysql server version 4.1.1
>
> Regards
> Luiz


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to