At 12:16 PM 5/7/2002, you wrote:
>Hello all,
>
>I wonder if someone could help me. I'm doing a query from a table via ODBC
>but I need to merge the results into a new table. What can I do?
>
>
>---------------------------------------------------------------------
Palofox,
You can also try "create table mytable1 select * from mytable2
where ...." if you want to create a new table from a query. You can also
create an empty table (maybe you prefer to use Insert instead) using
"create table if not exists mytable1 select * from mytable2 limit 0".
See also "create temporary table" if you want only that process to see the
table. http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Mike
