Results 1 to 2 of 2

Thread: insert select

  1. #1
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    19

    insert select

    Hi,

    insert ignore into table2 (some_id) select some_id from table1 where any_id=2

    I have 10 records for any_id 2, when i run the above query it will update 10 records only one record to table2.

    It will make any problem

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    can we see all your data please
    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
  •