Tag Info

New answers tagged

0

1) Consider how this information will be used. Will the owner want to try lots of ad hoc analysis and data exploration? Does your potential data store have tools or connection libraries that allow this? Will the user have to resort to writing Map and Reduce functions for every question posed? 2) Do you mean that the same question is on different ...


0

Well I see you are working on windows environment. There is a way that I use to do such imports from csv and I hope it helps you too. I am using a GUI tool called SQLyog. It is perfect for managing databases on mySQL and specially runs on Windows. So you can try it, it has options to import external data from csv directly and the empty columns are returned ...


0

Something like this, checking every value for '', and inserting NULL instead, may help. Change a,b,c,d for the actual name and number of rows on the table: $ cat /tmp/test.csv test1, test2, test3, test4 ,,, 1,2,3,4 ,,, mysql> LOAD DATA INFILE "/tmp/test.csv" INTO TABLE test.test FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ...



Top 50 recent answers are included