/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 vote334 views1 answer
How to change mysql port in xampp
SQL
3 votes378 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
4 votes354 views2 answers
Sql select except null
SQL
0 vote341 views1 answer
Mysql concat and use as where column
SQL
1 vote361 views1 answer
Postgres start database on linux
SQL
1 vote369 views1 answer
Age postgres
SQL
0 vote347 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote352 views2 answers
Reseed sql identity
SQL
0 vote371 views1 answer
Delete * from where id = 1;
SQL
1 vote354 views1 answer
Delete specific row in sql
SQL