Answers for "insert and select in one statement"

SQL
2

insert into with select but with one which is value

INSERT INTO table1 ( column1, column2, someInt, someVarChar )
SELECT  table2.column1, table2.column2, 8, 'some string etc.'
FROM    table2
WHERE   table2.ID = 7;
Posted by: Guest on January-17-2021

Code answers related to "insert and select in one statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language