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]
