/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 votes285 views1 answer
Define REGEXP?
SQL
0 vote297 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote292 views1 answer
Mysql sql.gz
SQL
0 vote269 views1 answer
Pl sql turn off variable substitution
SQL
0 vote292 views1 answer
Group by max date
SQL
24 votes278 views4 answers
Mssql get all table names
SQL
0 vote284 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote331 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote289 views1 answer
Date on SQL
SQL
1 vote322 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL