Insert into values select

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;

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;

Sql server insert into select

INSERT INTO sales.addresses (street, city, state, zip_code) 
SELECT
    street,
    city,
    state,
    zip_code
FROM
    sales.customers
ORDER BY
    first_name,
    last_name;

Source: sqlservertutorial.net

Insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

SQL Server INSERT INTO SELECT

 INSERT INTO table1
 SELECT col1, col2 , col3 FROM table2
 WHERE your condition;

Source: naycode.com

SQL Server INSERT INTO SELECT

 INSERT INTO salesTransaction_History
 SELECT * FROM salesTransaction
 WHERE item_Number='Salt-1';

Source: naycode.com

Similar codes

3 votes144 views1 answer
Oracle APEX elapsed time
SQL
0 vote530 views1 answer
How to connect .sql data set to powerbi
SQL
6 votes148 views4 answers
How to remove unique key in mysql
SQL
0 vote255 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote145 views1 answer
Mysql convert charset
SQL
0 vote174 views1 answer
Add two days to current date in sql when creating tables
SQL
23 votes155 views4 answers
How to uninstall postgresql in ubuntu
SQL
22 votes161 views3 answers
Remove all records from table mysql
SQL
16 votes190 views6 answers
Python sqlite
SQL
11 votes152 views1 answer
Mysql text type max length
SQL