Re: Null values in csv file with insert data
Posted by: Rick James
Date: May 05, 2015 09:57PM

Instead of having that column be a column name, use an @variable. Then SET col = IF(@variable = 'NULL', NULL, @variable).

There are a few examples in http://dev.mysql.com/doc/refman/5.6/en/load-data.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Null values in csv file with insert data
May 05, 2015 09:57PM


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.