#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    2
    Rep Power
    0
    Table one has a lot of data in it. Table two has the structure that I would like to use. How do I get the data from table one into table two quickly?

    thx in advance.

    DW
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    insert into table2 (field1,field2,field3,...) select fieldcorrespondingtotable2field1,fieldcorrespondingtotable2field2,... from table1;
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    2
    Rep Power
    0
    Thank you, Rod, for getting me on the right path -DW

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by rod k:
    insert into table2 (field1,field2,field3,...) select fieldcorrespondingtotable2field1,fieldcorrespondingtotable2field2,... from table1;[/quote]

Similar Threads

  1. League table problem
    By silverduck in forum MySQL Help
    Replies: 8
    Last Post: February 10th, 2004, 12:38 PM
  2. Replies: 0
    Last Post: January 30th, 2004, 02:18 PM
  3. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 06:19 PM
  4. Controlling Multiple table Heights in a Browser
    By AttaBoy in forum HTML Programming
    Replies: 1
    Last Post: December 10th, 2003, 04:24 AM
  5. Table structure for Dinner table design
    By PHP Addict in forum MySQL Help
    Replies: 1
    Last Post: November 27th, 2003, 07:50 AM

IMN logo majestic logo threadwatch logo seochat tools logo