/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

3 votes169 views2 answers
Enter mysql command line
SQL
0 vote147 views1 answer
Less than and between in sql query
SQL
17 votes142 views3 answers
Cast in sql server
SQL
0 vote135 views2 answers
Start mysql server using docker
SQL
13 votes164 views2 answers
Sqlite rename table
SQL
1 vote156 views1 answer
Select 2 rows in sql
SQL
0 vote150 views1 answer
Select year from dual oracle
SQL
0 vote131 views1 answer
Hw to delete a procedure in pl sql
SQL
2 votes128 views1 answer
Oracle sql drop table purge
SQL
0 vote184 views1 answer
Postgresql find biggest table
SQL