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]
