MySQL Forums
Forum List  »  Newbie

syntax error (EN, PT-BR) I'm Brazilian -- PLEASE HELP
Posted by: Ana Julia AnaJuuh
Date: July 30, 2014 06:34PM

i can't execute this command:

"USE ImovelNet;
CREATE TABLE oferta(
cdimovel integer,
cdcomprador integer,
vloferta number(16,2),
dtoferta date,
foreign key (vloferta))"

the error appears in the line "vloferta".
When i try execute, this error messege appears:

"Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'number(16,2), dtoferta date, primary key (vloferta))' at line 4'

EM PT-BR

Eu não consigo executar este comando:

"USE ImovelNet;
CREATE TABLE oferta(
cdimovel integer,
cdcomprador integer,
vloferta number(16,2),
dtoferta date,
primary key (vloferta))"

o erro aparece na linha "vloferta".
Quando eu tento executar, esta messagem de erro aparece:

"Código de erro: 1064 Você tem um erro em sua sintaxe SQL; verifique o manual que corresponde à sua versão do servidor MySQL para a sintaxe direita ao uso próximo 'número (16,2), dtoferta data, chave primária (vloferta))' na linha 4 '

Options: ReplyQuote


Subject
Written By
Posted
syntax error (EN, PT-BR) I'm Brazilian -- PLEASE HELP
July 30, 2014 06:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.