Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: updating records into RDBMS from a text file

by agoth (Chaplain)
on Jul 12, 2001 at 15:53 UTC ( [id://95982]=note: print w/replies, xml ) Need Help??


in reply to updating records into RDBMS from a text file

Broadly:
  • open the file
  • open database connection
  • Iterate over file
  • foreach line, extract the data you want
  • insert / update into database
Modules you might want to use:
DBI

You will more likely be better off doing more research on perl.com or searching this site for DBI / Database, then coming back with specific problems

  • Comment on Re: updating records into RDBMS from a text file

Replies are listed 'Best First'.
Re: Re: updating records into RDBMS from a text file
by Anonymous Monk on Jul 12, 2001 at 16:23 UTC
    Thanks Agoth, for your input! Joe

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2024-04-25 14:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found