DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data issue

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    data issue

    hello all

    due to various issues the application code entred data into a wrong column

    for example two tables


    customer data
    ------------------
    cdataid number(15) --- primary key
    customerinfoid number(10)
    customerid number(10).

    we inserted customerinfoid data into customerid column and vice-versa.

    Is there a easy way to change this???


    Pls let me know

    Thanks

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Code:
    UPDATE customer_data
    SET customerinfoid = customerid,
        customerid = customerinfoid;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    thanks

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    You could just rename the columns too. Obviously, it'll affect your dependant objects though.

Posting Permissions

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


Click Here to Expand Forum to Full Width