Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Overwriting entry in table

    Task:

    To insert entries into a table. The table has a primary key based on a field 'ID'. When inserting into the destination table, I want to make sure that the new entry will overwrite the old entry.

    What's the quickest/cleaniest way to do this ?

    thanks,
    Clayton

  2. #2
    Join Date
    Jun 2003
    Location
    Ottawa
    Posts
    105
    Code:
    UPDATE <table>
    SET <column>=<value>, etc...
    WHERE field_id = <field_id>
    You're obsessed and distressed 'cuz you can't make any sense
    Of the ludicrous nonsense and incipient senescence
    That will deem your common sense useless

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •