Sql create as select

This article is tagged with: Sql create as select and mysql

SELECT INTO

SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
FROM nome_da_tabela_que_estao_a_mexer

sql select into

SELECT CustomerName, ContactName INTO CustomersBackup2017
FROM Customers;

sql create as select

CREATE TABLE new_table_name AS
   
SELECT column1, column2,...
    FROM
existing_table_name
    WHERE ....;

This article is tagged with: Sql create as select and mysql