/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 vote221 views1 answer
Intellij mysql set timezone
SQL
0 vote198 views1 answer
T-sql update table variale
SQL
0 vote184 views1 answer
Import sql mysql ubuntu
SQL
2 votes220 views1 answer
Install postgresql centos 5
SQL
0 vote205 views1 answer
Guid string to binary better
SQL
4 votes194 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote291 views1 answer
Oracle previous year
SQL
0 vote204 views1 answer
Insert overwrite table in mysql in nifi
SQL
3 votes232 views1 answer
Oracle cannot access v$session
SQL
0 vote193 views1 answer
NLS_NCHAR_CHARACTERSET
SQL