1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
require('../UsineV2/bdd_c.php');
$query="LOAD DATA INFILE ./texte.txt
INTO TABLE CRM21_Fir_Histo (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,ParametrageVerifMarqueOICK,
HLR,TestCroiséeOK,FonctionnaitAvt,Mail,ServiceContenu,Wap_GPRS,NAM,
Descriptif,Reponse_Reseau,Reponse_Optim,Commentaire_Optim,Reponse_STC,
Champ50)
FIELDS
TERMINATED BY '|'
ENCLOSED BY |
LINES
STARTING BY ''
TERMINATED BY '\n' ";
$result_activities = mysql_query($query) or die ("Query Failed!");
echo 'test' |
Partager