/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

1 vote356 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote327 views1 answer
Initcap in mysql
SQL
0 vote334 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote347 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote349 views1 answer
Drop table if exists oracle
SQL
0 vote331 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote380 views1 answer
What is metadata in sql
SQL
0 vote308 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
1 vote370 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote326 views1 answer
Sequelize postgresql schema
SQL