How I Import file CSV into database

Hello,

I don't know how to Import CSV file into my database.Can you help me code it.thks

This article on Migrating Data Into Rails might be of interest to you:

http://blog.airbladesoftware.com/2006/12/5/migrating-data-into-rails

If you want to massage the values in your CSV file, you'll probably be better off using FasterCSV to read the CSV file, general Ruby to massage the data as desired, and finally Active Record to save the values in the database.

On the other hand, if you just want to lever the values straight into the database without alteration, it'll be quicker and simpler to use your database's batch import facility. There's a link to the MySQL one in the article above.

Regards, Andy Stewart