Re: perl for csv and sql...

2002-01-26 Thread Matt C.
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 ---

perl for csv and sql...

2002-01-26 Thread bc
i have some csv data: ex: 1,bart,555 3343 3456,main st 2,john,398 775 ,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 d