/SQL/Insert multiple rows from another table sql

Insert multiple rows from another table sql

Sql insert multiple rows from 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 multiple rows from another table sql

INSERT INTO NewTable SELECT * FROM ExistingTable;

Similar codes

0 vote335 views1 answer
Order by in codeigniter query builder
SQL
0 vote391 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote333 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote336 views1 answer
Convert rows to columns in sql server
SQL
0 vote341 views1 answer
Sql server list table sizes
SQL
0 vote367 views1 answer
Disable database droping sql
SQL
7 votes334 views3 answers
Restore postgres database from sql file
SQL
-1 vote323 views1 answer
Ssql to lowercqse
SQL
20 votes346 views6 answers
Mysql reset auto increment
SQL
1 vote337 views1 answer
Sql server cast date dd/mm/yyyy
SQL