MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: LOAD DATA INFILE with case Statement
Posted by: Peter Brawley
Date: January 11, 2017 08:37AM

You example would be OK ...

Load Data ...

...,@entity_code...,...

set entity_code = if(@entity_code = "Unwanted Varchar", 900001, @entity_code);

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
LOAD DATA INFILE with case Statement
Leon Claassen
January 04, 2017 07:28AM
Re: LOAD DATA INFILE with case Statement
Peter Brawley
January 04, 2017 09:39AM
Re: LOAD DATA INFILE with case Statement
Leon Claassen
January 05, 2017 05:55AM
Re: LOAD DATA INFILE with case Statement
Peter Brawley
January 05, 2017 11:45AM
Re: LOAD DATA INFILE with case Statement
Leon Claassen
January 10, 2017 01:36AM
Re: LOAD DATA INFILE with case Statement
Peter Brawley
January 10, 2017 08:57AM
Re: LOAD DATA INFILE with case Statement
Leon Claassen
January 11, 2017 02:01AM
Re: LOAD DATA INFILE with case Statement
Peter Brawley
January 11, 2017 08:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.