Answers for "how to insert inside a table using a select query"

insert a select statement into a table

--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;

Posted by: Guest on March-30-2020

select inside insert query

INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country FROM Suppliers;

#INSERT INTO table2 (column1, column2, column3, ...)
#SELECT column1, column2, column3, ...
#FROM table1
#WHERE condition;

Posted by: Guest on June-22-2021

Code answers related to "how to insert inside a table using a select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to insert inside a table using a select query"

Code answers related to "how to insert inside a table using a select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to insert inside a table using a select query"

Code answers related to "how to insert inside a table using a select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us