Re: Append one table to another?

[Paul DuBois]

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