Answers for "select from table and multi data and insert into another sql"

SQL
11

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;
Posted by: Guest on May-02-2021

Code answers related to "select from table and multi data and insert into another sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language