1 2 3 4 5 6 7 8 9 10 11 12 13
|
LOAD DATA LOCAL INFILE 'D:\UJV101.txt'
INTO TABLE FACT_OP
FIELDS
TERMINATED BY ';'
OPTIONALLY ENCLOSED BY '"'
LINES
TERMINATED BY '\r\n'
(@var1, @var2 ,@var3, @var4 , @var5 , @var6 , @var7 , @var8 , @var9 , @var10 )
SET IDDATES = CONCAT(SUBSTR(@var1,7,4),SUBSTR(@var1,4,2),SUBSTR(@var1,1,2)), IDPAYS = ' ' , IDHEURE = SUBSTR(@var7,13,2) , IDERT = ' ' ,
IDVISUEL = CONCAT('UJV',@var2) , IDCARTE = CONCAT('UJV',@var4) , IDPACKAGING = CONCAT('UJV',@var3) , IDDEVISE = @var5 , IDREPONSE = '
' , IDOPERATION = 101, IDAPPLICATION = 'UJV' , MONTANT = @var6 , MARGE = @var8 , FRAIS = @var9 ,
MONTANTTOTAL = @var10 |
Partager