Support the ongoing development of Laravel.io →
posted 9 years ago
Packages
Last updated 1 year ago.
0

sqlyog, and others like it. I believe phpadmin also, but not sure.

Last updated 9 years ago.
0

If using MySQL I would probably do this in a raw query using LOAD DATA LOCAL INFILE

0

Since you mentioned bulk data, I think it's better not to rely on any packages but the original tools your DBMS provided.

MySQL http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

mysqlimport  --ignore-lines=1 --fields-terminated-by=,
--columns='ID,Name,Phone,Address' --local -u root -p
Database /path/to/csvfile/TableName.csv 

MongoDB http://docs.mongodb.org/manual/reference/program/mongoimport/

#Mongo one is straight forward. Something like 
mongoimport  -h localhost -p 27017 -d mydb --type csv --file your_csv.csv -c your_collection --headerline

SQLite https://sqlite.org/cvstrac/wiki?p=ImportingFiles

Last updated 9 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

tadoshi tadoshi Joined 17 Dec 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.