From db8f6227d53e3be99f01671a9d5536a20ebbab2f Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Fri, 10 Dec 2010 15:28:33 +0100 Subject: [PATCH] Trims corps before inserting them. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- modules/fusionax/Anciens.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/modules/fusionax/Anciens.sql b/modules/fusionax/Anciens.sql index af12e11..c6d84d6 100644 --- a/modules/fusionax/Anciens.sql +++ b/modules/fusionax/Anciens.sql @@ -35,6 +35,7 @@ SET -- Mel_publiable is not certain yet :/ ALTER TABLE fusionax_anciens ADD INDEX (ax_id); +UPDATE fusionax_anciens SET corps_sortie = TRIM(corps_sortie), grade = TRIM(grade); -- Correspondances entre fiches X.org et fiches AX DROP TABLE IF EXISTS `fusionax_import`; -- 2.1.4