Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Reading from a file

by Anonymous Monk
on Apr 04, 2000 at 00:30 UTC ( #6752=note: print w/replies, xml ) Need Help??

in reply to Reading from a file, writing to a database

Plus, that may not be a valid insert statement... Try:  insert into TABLE_NAME values (... Zak

Replies are listed 'Best First'.
RE: Re: Reading from a file
by plaid (Chaplain) on Apr 04, 2000 at 00:40 UTC
    Actually, that is a valid insert statement. The field names specified after the 'INSERT INTO NEW' specifies which fields to insert into, saving the insert statement from having to provide initial values for each field in the database, and making it a lot easier to manage if a field with a default were to get added later on.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2022-06-30 21:54 GMT
Find Nodes?
    Voting Booth?
    My most frequent journeys are powered by:

    Results (98 votes). Check out past polls.