#1064 - Erreur de syntaxe près de 'VARCHAR2 (30) not null,......

Question

Bonjour à tout le monde...   
je voudrais créer une table sous le nom de Répartition. je n'arrive pas à voir là où se situe l'erreur au niveau du code...Aidez-moi SVP????  
voici la requête sql:  

CREATE TABLE 'Repartition' (  
'id' int(11) NOT NULL AUTO_INCREMENT,   
'EVENT_INST_I' INT(12) not null,   
'RE_ID' INT(6) not null,  
'BILLING_NBR' VARCHAR2 (30) not null,   
'BILLING_IMSI' VARCHAR2(30) not null,   
'CALLING_NBR' VARCHAR2(30) not null,   
'CALLED_NBR' VARCHAR2(30) not null,   
'THIRD_PART_NBR' VARCHAR2(30) not null,   
'START_TIME' DATETIME not null,   
'DURATION' INT(6) not null,   
'TRUNK_OUT' VARCHAR2(30) not null,   
'TRUNK_IN' VARCHAR2(30)not null,   
'EVENT_SRC_ID' NUMBER(6) not null,   
'FILE_ID' NUMBER(9) not null,   
'RECORD_SEQ' NUMBER(9) not null,   
'CELL_A' VARCHAR2(30) not null,   
'CELL_B' VARCHAR2(30) not null,   
'MSRN' VARCHAR2(30) not null,   
'CALLING_IMEI' VARCHAR2(30) not null,   
'CALLED_IMEI' VARCHAR2(30) not null,   
'ACCT_RES_ID1' NUMBER(9) not null,   
'ACCT_RES_ID2' NUMBER(9) not null,   
'ACCT_RES_ID3' NUMBER(9) not null,   
'ACCT_RES_ID4' NUMBER(9) not null,   
'PRICE_PLAN_ID_1' NUMBER(6) not null,   
'PRICE_PLAN_ID_2' NUMBER(6) not null,   
'PRICE_PLAN_ID_3' NUMBER(6) not null,   
'PRICE_PLAN_ID_4' NUMBER(6) not null,   
'CHARGE1' NUMBER(12) not null,   
'CHARGE2' NUMBER(12) not null,   
'CHARGE3' NUMBER(12) not null,   
'CHARGE4' NUMBER(12) not null,   
'PRE_BALANCE1' NUMBER(12) not null,   
'BALANCE1' NUMBER(12) not null,   
'PRE_BALANCE2' NUMBER(12) not null,   
'BALANCE2' NUMBER(12) not null,   
'PRE_BALANCE3' NUMBER(12) not null,   
'BALANCE3' NUMBER(12) not null,   
'PRE_BALANCE4' NUMBER(12) not null,   
'BALANCE4' NUMBER(12) not null,   
'SERVICE_TYPE' NUMBER(6) not null,   
'PREPAY_FLAG' NUMBER(1) not null,   
'CurrencyType' NUMBER(3) not null,   
'Roaming flag' NUMBER(3) not null,   
'Charging Identifier' NUMBER(3) not null,   
'CDR Split Identifier' NUMBER(3) not null,   
'Rating Group ID' NUMBER(10) not null,   
'Calling Number VLR Number' VARCHAR2(30) not null,   
'Called Number VLR Number' VARCHAR2(30) not null,   
'MSC Call Reference Number' VARCHAR2(30) not null,   
'CCR Release Cause' NUMBER(3) not null,   
'Dialling APN' NUMBER(8) not null,   
'Dialled APN' NUMBER(8) not null,   
'OperatorID' NUMBER(3) not null,   
'ProviderId' NUMBER(3) not null,   
'surcharged SMS' NUMBER(3) not null,   
'Service Continuity ID'  NUMBER(3) not null,   
'Charging Type' NUMBER(3) not null,   
'Version' CHAR(30) not null,   
'Service key' NUMBER(6) not null,   
'Discount' Number(3) not null,   
'TotalChargeAmount' NUMBER(12) not null,   
'CallSetupTime' NUMBER(6) not null,   
PRIMARY KEY (id))

A.Nonymous · Accepted Answer

C'est sûr que si on avait eu le SGBD, ça deviendrait trop facile à répondre :/

Submin · Answer

Tu peux essayé si ça te convient? 

CREATE TABLE AAA3 ( 
"id" int NOT NULL AUTO_INCREMENT, 
"EVENT_INST_I" NUMBER(12) not null, 
"RE_ID" NUMBER(6) not null, 
"BILLING_NBR" VARCHAR2 (30) not null, 
"BILLING_IMSI" VARCHAR2(30) not null, 
"CALLING_NBR" VARCHAR2(30) not null, 
"CALLED_NBR" VARCHAR2(30) not null, 
"THIRD_PART_NBR" VARCHAR2(30) not null, 
"START_TIME" DATE not null, 
"DURATION" NUMBER(6) not null, 
"TRUNK_OUT" VARCHAR2(30) not null, 
"TRUNK_IN" VARCHAR2(30)not null, 
"EVENT_SRC_ID" NUMBER(6) not null, 
"FILE_ID" NUMBER(9) not null, 
"RECORD_SEQ" NUMBER(9) not null, 
"CELL_A" VARCHAR2(30) not null, 
"CELL_B" VARCHAR2(30) not null, 
"MSRN" VARCHAR2(30) not null, 
"CALLING_IMEI" VARCHAR2(30) not null, 
"CALLED_IMEI" VARCHAR2(30) not null, 
"ACCT_RES_ID1" NUMBER(9) not null, 
"ACCT_RES_ID2" NUMBER(9) not null, 
"ACCT_RES_ID3" NUMBER(9) not null, 
"ACCT_RES_ID4" NUMBER(9) not null, 
"PRICE_PLAN_ID_1" NUMBER(6) not null, 
"PRICE_PLAN_ID_2" NUMBER(6) not null, 
"PRICE_PLAN_ID_3" NUMBER(6) not null, 
"PRICE_PLAN_ID_4" NUMBER(6) not null, 
"CHARGE1" NUMBER(12) not null, 
"CHARGE2" NUMBER(12) not null, 
"CHARGE3" NUMBER(12) not null, 
"CHARGE4" NUMBER(12) not null, 
"PRE_BALANCE1" NUMBER(12) not null, 
"BALANCE1" NUMBER(12) not null, 
"PRE_BALANCE2" NUMBER(12) not null, 
"BALANCE2" NUMBER(12) not null, 
"PRE_BALANCE3" NUMBER(12) not null, 
"BALANCE3" NUMBER(12) not null, 
"PRE_BALANCE4" NUMBER(12) not null, 
"BALANCE4" NUMBER(12) not null, 
"SERVICE_TYPE" NUMBER(6) not null, 
"PREPAY_FLAG" NUMBER(1) not null, 
"CurrencyType" NUMBER(3) not null, 
"Roaming flag" NUMBER(3) not null, 
"Charging Identifier" NUMBER(3) not null, 
"CDR Split Identifier" NUMBER(3) not null, 
"Rating Group ID" NUMBER(10) not null, 
"Calling Number VLR Number" VARCHAR2(30) not null, 
"Called Number VLR Number" VARCHAR2(30) not null, 
"MSC Call Reference Number" VARCHAR2(30) not null, 
"CCR Release Cause" NUMBER(3) not null, 
"Dialling APN" NUMBER(8) not null, 
"Dialled APN" NUMBER(8) not null, 
"OperatorID" NUMBER(3) not null, 
"ProviderId" NUMBER(3) not null, 
"surcharged SMS" NUMBER(3) not null, 
"Service Continuity ID" NUMBER(3) not null, 
"Charging Type" NUMBER(3) not null, 
"Version" CHAR(30) not null, 
"Service key" NUMBER(6) not null, 
"Discount" Number(3) not null, 
"TotalChargeAmount" NUMBER(12) not null, 
"CallSetupTime" NUMBER(6) not null, 
PRIMARY KEY ("id"));

Freedomsoul · Answer

manque un espace à la ligne :
"TRUNK_IN" VARCHAR2(30)not null, 
avant le "not"

young lord · Answer

je pense que c'est la version et ou l'application qui n'acceptait pas les types VARCHAR2 et NUMBER..j'avais le EASYPHP 5.3.3...  
J'ai remplacé les types VARCHAR2 par VARCHAR tout court et NUMBER par INT..voilà et ca a marché 
et merci de votre aide...slt

Freedomsoul · Answer

ah, bon à savoir, merci

#1064 - Erreur de syntaxe près de 'VARCHAR2 (30) not null,......

5 réponses

Votre réponse

Discussions similaires

Newsletters