0

Insert into and select

Put a new row with insert into and then select

19th Dec 2020, 10:27 PM
Diamonq
Diamonq - avatar
3 Answers
+ 3
First learn SQL about insert
20th Dec 2020, 12:45 AM
Sâñtôsh
Sâñtôsh - avatar
0
Done, now what?
21st Dec 2020, 3:09 PM
Diamonq
Diamonq - avatar
0
There's two main ways to insert using select. The first can be used on existing tables and the second only works to create a table. I think the second one only works on temp tables but I havent confirmed. INSERT INTO schema.table (col1, col2, ...) SELECT col1, col2, ... FROM schema.other_table WHERE modifier_column = [value] Or SELECT col1, col2, ... INTO #table FROM schema.other_table WHERE modifier_column = [value]
10th Jan 2021, 2:11 AM
No Comment
No Comment - avatar