Re: Can't Bulk Load CSV with blank fields
Posted by: Peter Brawley
Date: February 17, 2016 05:35PM

> would prefer not to have to preprocess these large text files to inject the word NULL

Interpreting consecutive commas as meaning NULL would be inconsistent with the rest of SQL, which does not support such syntax.

> tried using LOAD DATA INFILE statements in stored procedures. But unfortunately MySQL does not permit that

I think Load Data is prevented in sprocs because of security concerns. No sign of that changing.

> It's like I'm being deliberately thwarted

?! Get a grip. MySQL is a database platform, not an application development system. SQL is not a complete computer language nor was meant to be. All you need do is write a preprocessing function in your preferred programming language.



Edited 1 time(s). Last edit at 02/17/2016 05:38PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't Bulk Load CSV with blank fields
February 17, 2016 05:35PM


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.