If you're using MySQL (and I'm sure several others) you can skip this whole step and
use mysqlimport. Run the command without arguments and it'll spit out some help. You
just tell it what the fields are terminated by and it'll split around them and
import into your db. Fast and easy.
Matt
--- bc <[EMAIL PROTECTED]> wrote:
> i have some csv data:
>
> ex:
>
> 1,bart,555 3343 3456,main st
> 2,john,398 775 3333,3rd road
> 3......
> etc... to about 150 or so
>
> anyway, i want to use perl to make the sql statement:
>
>
INSERT into $TABLE (field1, field2, field3...) VALUES ('value1','value2','value3'...);
>
> and the values are the csv data, one of these sentences for each row
>
> so it looks like i want to put
>
> " insert into tablename(id, name, phone...) values(' " , $CSV_ROW_STRING, " ); "
>
> and i have a cgi-bin directory i'm gonna use for this... in a browser... ???
>
> any ideas?
>
> the csv is a file named csv_rows.csv
>
> thanks,
> bc
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
