converting non-materialized view to a table?

converting non-materialized view to a table?

am 14.01.2010 23:55:12 von Jacek Becla

Hello,

I need to convert a non-materialized MySQL view to
a MySQL table. Are there any tools to do that?

Thanks,
Jacek

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: converting non-materialized view to a table?

am 15.01.2010 00:23:32 von mos

At 04:55 PM 1/14/2010, Jacek Becla wrote:
>Hello,
>
>I need to convert a non-materialized MySQL view to
>a MySQL table. Are there any tools to do that?
>
>Thanks,
>Jacek


Jacek,
Can't you just do a:

create table mytable select * from myview;

???
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org