List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 11 2005 3:13pm
Subject:Re: Append one table to another?
View as plain text  
At 7:57 -0700 10/11/05, Brian Dunning wrote:
>How do I append one table's contents to another? Both have identical 
>structure. Problem is I don't have shell access, only phpAdmin or a 
>PHP file I write & upload myself.

If the tables are identical, you can do this:

INSERT INTO t2 SELECT * FROM t1;

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Append one table to another?Brian Dunning11 Oct
  • Re: Append one table to another?Paul DuBois11 Oct
  • Re: Append one table to another?Peter Brawley11 Oct
    • Re: Append one table to another?Brian Dunning11 Oct
      • Re: Append one table to another?Paul DuBois11 Oct
  • Re: Append one table to another?Jose Miguel PĂ©rez11 Oct
    • Re: Append one table to another?Brian Dunning11 Oct