Re: How to move data between tables in a database?

[harm]

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)