/SQL/Sql insert multiple rows from select

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;

Similar codes

2 votes344 views2 answers
Created at and updated at in mysql
SQL
0 vote379 views1 answer
Having all mysql
SQL
3 votes345 views2 answers
Find string in stored procedure sql server
SQL
8 votes326 views1 answer
Mysql restore database
SQL
1 vote315 views1 answer
Mysql select utc time in eastern time
SQL
25 votes338 views3 answers
Mysql command show tables
SQL
0 vote327 views1 answer
Dnsmasq.conf location macos
SQL
2 votes313 views3 answers
Application.properties spring boot mysql
SQL
0 vote336 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote351 views1 answer
SAP Return
SQL