Home/ Questions/How to select into existing table in sql?
Next
In Process
Javier Wilson
  • 15
Asked: 2022-04-18T02:58:51+00:00 In:

How to select into existing table in sql?

  • 15

. Advertisement .

..3..

. Advertisement .

..4..

How do I select into existing table in sql? Your suggestions would help me a lot.

♦ Suggestions of ITtutoria Team
Idea for “select into existing table in sql”: When you want to select data into an existing table in SQL, it can be a little difficult. This is because it’s not possible with the standard SELECT query to just query for columns that already exist.

Here is a case study 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

2 Answers

  1. INSERT INTO table2
SELECT * FROM table1
WHERE condition;
    • 13
  2. INSERT INTO cdrs.client_feed_mapping SELECT * FROM cdrs.client_feed_mapping_backup;
    • 11

Leave an answer

You must login to add an answer.

Need An Account,