Erro on Query
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]
Re: Erro on Query
Luiz Rafael Culik Guimaraes wrote: Dear Friends. when Creating the follow table I got an Erro when defining Column DESC(same error even if DESC is between ) DESC is a reserved word, try something else. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Erro on Query
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]