/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 votes269 views2 answers
Brew restart mysql
SQL
0 vote268 views1 answer
Get relation data in mysql using query to excel
SQL
4 votes264 views1 answer
Change nls_date_format
SQL
21 votes280 views1 answer
Cheatsheet for sql
SQL
1 vote263 views1 answer
Python clean sql string
SQL
4 votes305 views4 answers
Remove duplicate old value in mysql
SQL
0 vote275 views1 answer
OFFSET consulta mysql
SQL
3 votes265 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote265 views1 answer
Jooq convert using gbk
SQL
11 votes695 views4 answers
Reset identity column values in sql server
SQL