List:General Discussion« Previous MessageNext Message »
From:harm Date:January 12 2004 8:05pm
Subject:Re: How to move data between tables in a database?
View as plain text  
On Mon, Jan 12, 2004 at 12:54:55PM -0500, Syed Ali wrote:
> Hello,
> 
> I would like to move data between tables in mysql within the same
> database, I am not sure what the best way to go about it is.
> I do not need to move all the data in the tables, just the output of
> some select statements.

create newtable select * from oldtable where what_i_want=42;


good luck.
-- 
                                The Moon is Waning Gibbous (75% of Full)
Thread
How to move data between tables in a database?Syed Ali12 Jan
  • Re: How to move data between tables in a database?harm12 Jan
Re: How to move data between tables in a database?jeffrey_n_Dyke12 Jan