Answers for "sql insert multiple rows from select"

SQL
3

sql insert multiple rows from select

INSERT INTO table2
     (name, email, phone)
     SELECT name, email, phone
     FROM table1;
Posted by: Guest on June-14-2021
10

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 "sql insert multiple rows from select"

Code answers related to "SQL"

Browse Popular Code Answers by Language