Обсуждение: new table with a select

Поиск
Список
Период
Сортировка

new table with a select

От
ppdcc@sapo.pt
Дата:
Hello to all,


Can anybody tell me the sql instruction to create a new table with a  
select of other table?

I need to create a new table based on paralell of a table of lines.  
Can anybody post to me a example?

Can?t be a buffer, must be lines.

Thanks

Re: new table with a select

От
MIkhail Puzanov
Дата:
Hi,


2011/8/25 <ppdcc@sapo.pt>
Hello to all,


Can anybody tell me the sql instruction to create a new table with a select of other table?

I need to create a new table based on paralell of a table of lines. Can anybody post to me a example?

 
CREATE TABLE t AS
SELECT * FROM x;