1 -- Import complet des formations
3 DROP TABLE IF EXISTS `fusionax_formations`
;
5 CREATE TABLE IF NOT EXISTS `fusionax_formations`
(
6 `FO`
CHAR(2) NOT NULL COMMENT 'Vaut toujours FO pour cette table',
7 `id_ancien`
VARCHAR(8) NOT NULL COMMENT 'Id unique de l''ancien',
8 `Intitule_formation`
VARCHAR(60) collate utf8_unicode_ci
NOT NULL COMMENT 'Intitulé de la formation',
9 `Date_maj`
DATE NOT NULL COMMENT 'Date de mise à jour de ces informations',
10 PRIMARY KEY (`id_ancien`
, `Intitule_formation`
)
11 ) ENGINE
=MyISAM
DEFAULT CHARSET
=utf8
COLLATE=utf8_unicode_ci
;
13 LOAD DATA LOCAL INFILE
'Formations.txt' INTO TABLE `fusionax_formations` FIELDS TERMINATED
BY '\t' LINES TERMINATED
BY '\r\n'
14 (FO
, id_ancien
, Intitule_formation
, @StringDate_maj
)
16 `Date_maj`
= CONCAT(SUBSTRING(@StringDate_maj
,7),'-',SUBSTRING(@StringDate_maj
,4,2),'-',SUBSTRING(@StringDate_maj
,1,2));