Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2004
    Location
    Dallas, TX
    Posts
    77

    Unanswered: how to insert row from select row

    i have table A which has the column b as auto increment number, and other column c, d, e
    I want to insert one row from the row in exact same table but change the clumn b which is auto increment number

    I did like this:

    insert into A
    select c, d, e from A where b =xxxx

    error is: due to key violation,
    I don't know how to insert the key into table.

    anybody have some idea about this?

    thanks a lot. appreciate for your help
    Last edited by huela; 09-29-04 at 19:58.

Posting Permissions

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