Answers for "get insert query from select query"

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

insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Posted by: Guest on June-30-2020

Code answers related to "get insert query from select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get insert query from select query"

Code answers related to "get insert query from select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get insert query from select query"

Code answers related to "get insert query from select query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us