Results 1 to 2 of 2

Thread: Data Swap

  1. 07-14-2004, 06:56 AM #1
    KishoreNM
    KishoreNM is offline Registered User
    Join Date
    Jul 2004
    Posts
    1

    Angry Data Swap

    I have two tables

    Bother having id, name colums
    data should be swaped from one table to another table . Like Renameing the tables, I want data should be Inter changed

    Thanks In Advance
    Reply With Quote Reply With Quote
  2. 07-14-2004, 02:24 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can rename the tables.

    Rename table1 to tabletemp
    Rename table2 to table1
    Rename tabletemp to table2
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules