/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

0 vote173 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
3 votes159 views1 answer
Select table column in sql
SQL
1 vote155 views1 answer
Find a column in all tables postgres
SQL
0 vote145 views1 answer
Char varchar nvarchar sql
SQL
1 vote153 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
1 vote167 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
4 votes147 views2 answers
Sql server date now
SQL
0 vote202 views1 answer
Drop view sql
SQL
0 vote170 views1 answer
Regex any word except sql
SQL
3 votes152 views1 answer
Fk in insert mysql
SQL