How to LOAD DATA LOCAL INFILE using @column with if statement

user_7375707 0
Viewed 103

I need to set color based on color code using @set on Load Data Local INFILE

 LOAD DATA LOCAL INFILE "'.$file.'"
        INTO TABLE '.$table.'
        FIELDS TERMINATED by \',\'
        ENCLOSED BY \'"\'
        ESCAPED BY \'"\'
        LINES TERMINATED BY \'\n\'
        (Brand, @Color, @Year)
        SET
        Color = if (@Color = "1b"){ Color = "Blue" } else { Color = "Green" },
        Year = "2022"
load-data-infile mysql php
1 Answers

you have to use the mysql style of the if clause

LOAD DATA LOCAL INFILE "'.$file.'"
        INTO TABLE '.$table.'
        FIELDS TERMINATED by \',\'
        ENCLOSED BY \'"\'
        ESCAPED BY \'"\'
        LINES TERMINATED BY \'\n\'
        (Brand, @Color, @Year)
        SET
        Color = if (@Color = '1b',  'Blue' ,  'Green' ),
        Year = "2022"

For more option

LOAD DATA LOCAL INFILE "'.$file.'"
        INTO TABLE '.$table.'
        FIELDS TERMINATED by \',\'
        ENCLOSED BY \'"\'
        ESCAPED BY \'"\'
        LINES TERMINATED BY \'\n\'
        (Brand, @Color, @Year)
        SET
        Color = CASE @Color 
        WHEN '1b' THEN  'Blue' 
        WHEN '2b' THEN 'brown'
        ELSE  'Green' 
        END,
        Year = "2022"
user_51935360
Related