In the docs, search for CREATE TABLE syntax.
There is something like
CREATE TABLE tbl_name SELECT some_fields FROM some_table WHERE
where_condition ....
I don't remember exactly but you should find useful information in the docs
of the MySQL website.
Thanks
Emery
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 11:19
Subject: creating a new table from a SELECT
> how can i create a new table from a SELECT...WHERE... ?
>
> thanks
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
