Home/ Questions/How to select insert into new table?
Next
In Process
Hallie Wang
  • 27
Asked: 2022-04-18T02:44:43+00:00 In:

How to select insert into new table?

  • 27

. Advertisement .

..3..

. Advertisement .

..4..

How do I select insert into new table? Your suggestions would help me a lot.

♦ Suggestions of ITtutoria Team
Idea for “select insert into new table”: They can also be used to create a new table in Microsoft Excel by selecting Insert into new table.

Here is a suggestion for you

--format
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;
​
--examples
INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;
Share

3 Answers

  1. INSERT INTO table2
SELECT * FROM table1
WHERE condition;
    • 21
  2.  SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
 FROM nome_da_tabela_que_estao_a_mexer
    • 20

  3. Do you think this might be a solution? 

    SELECT *
INTO [new_BK]
FROM [old_table]
​
    • 17

Leave an answer

You must login to add an answer.

Need An Account,