Criar tabela usando select – CREATE TABLE AS SELECT

Posted by Bento | Posted in Artigos, Banco de Dados, MariaDB, MySQL, Oracle, PostgreSQL | Posted on 07-12-2013-05-2008

0

CREATE TABLE AS SELECT

CREATE table dados_bkp AS SELECT * from dados_originais

CREATE TABLE dados_backup AS
SELECT * FROM dados_originais WHERE data_alteracao >= ‘2013-01-01’;

Write a comment