How do i insert into a MySQL db from a file?

Question

My table has around 190 fields. Out of which only 30 cannot be null. And around 7k rows are to be inserted.

I am using JDBC. Is there anyway of inputting all these directly from a text file in a single INSERT instead of doing an INSERT statement 7k times.

maybe you can use import in MySQL check this out cyberciti.biz/faq/… — youssDev
– youssDev, Commented Feb 23, 2013 at 9:53

Achrome · Accepted Answer · 2013-02-23 09:54:49Z

1

If you want to write a query itself, you can use LOAD DATA INFILE. It is a very fast method of importing a file. However, the file has to be properly formatted.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

answered Feb 23, 2013 at 9:54

Achrome

7,82114 gold badges38 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do i insert into a MySQL db from a file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related