Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Database

by screamingeagle (Curate)
on Jul 16, 2002 at 16:57 UTC ( #182153=note: print w/replies, xml ) Need Help??

in reply to Import CSV to Database

i'm not acquainted with the file structure you're using, but if every log file has the same data format, i would recommend against creating a new table for each file you process...that would be redundant... if you know the format beforehand , create a table using the Enterprise Manager in SQL 7 , and let your perl script insert data into that table for all the log files you process...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://182153]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (15)
As of 2016-10-25 20:15 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (330 votes). Check out past polls.