1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
<?
require('../UsineV2/connexion.php');
$query=("LOAD DATA INFILE '../UsineV2/texte.txt'
INTO TABLE CRM21_Fir_Histo
FIELDS
TERMINATED BY '|'
ENCLOSED BY ''
ESCAPED BY '\\'
LINES
STARTING BY ''
TERMINATED BY '\n'
(Nomad/Forfait,Num_compte_client,Contrat,StatutContrat,NumMobile,Motif,
CommentDossier,Univers,Numero_action,Theme,Action1,Action2,Etat,
Demandeur,Date_de_creation_action,DateEffetSouhaite,DateEffetReel,
Competence_destinataire,CdcDest,SiteCdcDest,EquipeCdcDest,Media,
NumeroContact,CdcCreateur,SiteCdcCreateur,EquipeCdcCreateur,
CdcModificateur,DateModifAction,NumMobile_Fax,Modele,Expediteur,
Destinataire,Date/Heure,Lieu,CodePostal,ParametrageVerif,MarqueOICK,
HLR,TestCroiséeOK,FonctionnaitAvt,Mail,ServiceContenu,Wap_GPRS,NAM,
Descriptif,Reponse_Reseau,Reponse_Optim,Commentaire_Optim,
Reponse_STC,Champ50) ");
$result_activities = mysql_query($query) or die (mysql_error());
?> |
Partager