http://qs321.pair.com?node_id=6752


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.