Answers for "how to insert records in table based on another table sql"

SQL
2

get value from a table an insert it with other values in another table sql

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
0

create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;
Posted by: Guest on May-13-2021

Code answers related to "how to insert records in table based on another table sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language