Re: Can't Bulk Load CSV with blank fields
Unfortunately I have no control over the generation of the CSV files - they are provided to us on a daily basis by an external organisation. Having to preprocess the text files just to have blanks interpreted as NULL rather than 0 is so inefficient. Looking around various forums I see that this problem has been around for many years without a real solution.
I've now also tried using LOAD DATA INFILE statements in stored procedures. But unfortunately MySQL does not permit that either. It's like I'm being deliberately thwarted at every turn to try and get this data into my database!
I realise it's not a "bug". But then again why should a blank field really be interpreted as a 0 - particularly if the default value for a field has been defined as NULL?
Subject
Written By
Posted
February 07, 2016 05:41PM
February 09, 2016 02:57PM
Re: Can't Bulk Load CSV with blank fields
February 17, 2016 04:03PM
February 17, 2016 05:35PM
February 17, 2016 06:19PM
February 17, 2016 09:21PM
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.