CSV into mysql
Moderator: General Moderators
CSV into mysql
Does anyone know how to insert a CSV file into mysql? thanks!
I thought you just have to use the php function file_get_contents(foo.cvs)
and save it in a largetext or largeblob field. But after some testing I found out
(as you already might know) that strings larger than 1024 kB wont be saved.
MySQL just ignores the query and does not return an error msg.
Thanx to g
gle I found this.
http://perlmonks.thepen.com/150255.html
Hope this helps
and save it in a largetext or largeblob field. But after some testing I found out
(as you already might know) that strings larger than 1024 kB wont be saved.
MySQL just ignores the query and does not return an error msg.
Thanx to g
http://perlmonks.thepen.com/150255.html
Hope this helps