1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
LOAD DATA LOCAL INFILE '?????????????'
INTO TABLE tbl_g_temp
FIELDS
TERMINATED BY '|'
ENCLOSED BY ''
ESCAPED BY '\\\\'
LINES
STARTING BY ''
TERMINATED BY '\\n'
(NomadForfait,NumCompteClient,Contrat,StatutContrat,NumMobile,Motif,
CommentDossier,Univers,NumeroAction,Theme,Action1,Action2,Etat,
Demandeur,DateCreationAction,DateEffetSouhaite,DateEffetReel,
CompetenceDestinataire,CdcDest,SiteCdcDest,EquipeCdcDest,Media,
NumeroContact,CdcCreateur,SiteCdcCreateur,EquipeCdcCreateur,
CdcModificateur,DateModifAction,NumMobileFax,Modele,Expediteur,
Destinataire,DateHeure,Lieu,CodePostal,ParametrageVerif,MarqueOICK,
HLR,TestCroiseOK,FonctionnaitAvt,Mail,ServiceContenu,WapGPRS,NAM,
Descriptif,ReponseReseau,ReponseOptim,CommentaireOptim,ReponseSTC,
TypeProbSTC); |
Partager