script to load data from csv file

srpa01red · #1 (**permalink**) 03-30-2009

hello

i want a script to load the data line by line from a csv file into a mysql
table

z1dane · #2 (**permalink**) 03-30-2009

For a Perl solution, look at the DBI module.

hansw · #3 (**permalink**) 03-30-2009

It is possible to use: load data local

Please be aware that you need to be able to rcp, ftp, scp the csv file to the server and give the user needing to import the file permissions for this action.

Housni · #4 (**permalink**) 04-11-2009

If you know some PHP, you can, pretty easily, put together something in a few minutes using fgetcsv() or str_getcsv().

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Load data to flat file from table.	Haque123	Shell Programming and Scripting	4	03-12-2009 07:33 AM
load a data from text file into a oracle table	raji35	Shell Programming and Scripting	2	01-15-2009 03:48 AM
shell script to read data from text file and to load it into a table in TOAD	pallavishetty	Shell Programming and Scripting	1	10-31-2008 04:15 AM
How to load different type of data in a file to two arrays	ahjiefreak	Shell Programming and Scripting	5	10-09-2008 09:53 AM
Shell Script to Load data into the database using a .csv file and .ctl file	Csmani	Shell Programming and Scripting	3	05-24-2006 08:09 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by