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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
