Results 1 to 2 of 2

Thread: transfer data

  1. #1
    Join Date
    Nov 2011

    Unanswered: transfer data

    How can I transfer data (email address & phone #'s) from one table to another table in a specific tab named work_2?
    Last edited by gace16; 11-08-11 at 12:56.

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    I am thinking "specific tab" refers to a specific table? If this is the case you can do the following:

    INSERT INTO newtable (email, phone) 
    SELECT email, phone FROM oldtable;
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

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