2012/06/15 18:14 +0900, Tsubasa Tanaka
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.html
"Try" is the operative word: MySQL s character format is _like_ CSV, but not
the same. The treatment of NULL is doubtless the bigg
Let's see
SHOW CREATE TABLE ...
SELECT ...
It sounds doable with MySQL; might be too big for NOSQL.
> -Original Message-
> From: abhishek jain [mailto:abhishek.netj...@gmail.com]
> Sent: Friday, June 15, 2012 1:57 AM
> To: mysql@lists.mysql.com
> Subject: Which Database when lot of insert
Hello,
> I am designing a solution which will need me to import from CSV, i am using
> my JAVA code to parse. CSV file has 500K rows, and i need to do it thrice
> an hour, for 10 hours a day.
try to use `LOAD DATA INFILE' to import from CSV file.
http://dev.mysql.com/doc/refman/5.5/en/load-data.
