/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

2 votes125 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote114 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote116 views1 answer
Sql count * vs count 1
SQL
1 vote112 views1 answer
Mysql connect bash
SQL
-1 vote111 views2 answers
Get day in sql
SQL
0 vote120 views1 answer
Dataframe lambda elif
SQL
0 vote116 views1 answer
Const pool = mysql.createpool()
SQL
5 votes113 views4 answers
Mysql update column with value from another table
SQL
3 votes163 views1 answer
Apex call duration
SQL
0 vote111 views3 answers
Postgres trim string
SQL