Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    62

    Unanswered: Updating 100K data against 1M data

    Greetings,
    I have a table with millions of data with this structure:
    callrequest (
    serialno varchar(20) default '0',
    callno varchar(20) default null
    ). Currently this table has no callno for some of the records

    Another temporary table with the same structure, holds a temporary data around 100K records, and this data will be purged daily, as data keeps on coming everyday around 100K and update callno in the main table


    How can i do that with a very efficient way. Thank you

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    have you seen the multi-table UPDATE syntax in the manual? that will do what you want
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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