From: Peter Brawley
Date: October 11 2005 3:15pm
Subject: Re: Append one table to another?
List-Archive: http://lists.mysql.com/mysql/190245
Message-Id: <434BD716.3070307@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Brian

 >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.

How about

  INSERT into tbl1 SELECT * FROM tbl2

PB

>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/128 - Release Date: 10/10/2005