W3. SQL Insert Into Select

Question 1

Q: What does the SQL INSERT INTO SELECT statement do?

Answer 1

A: It copies data from one table and inserts it into another table.

Question 2

Q: Does INSERT INTO SELECT affect existing records in the target table?

Answer 2

A: No, it only adds new records and leaves existing records unaffected.

Question 3

Q: What must be true about the data types when using INSERT INTO SELECT?

Answer 3

A: The data types in the source and target tables must match.

Question 4

Q: Write the syntax for copying all columns from one table to another.

Answer 4

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Question 5

Q: Write the syntax for copying specific columns from one table to another.

Answer 5

INSERT INTO table2 (column1, column2, …)
SELECT column1, column2, …
FROM table1
WHERE condition;

Question 6

Q: Write a query to copy SupplierName, City, and Country from Suppliers to Customers.

Answer 6

INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country
FROM Suppliers;

Question 7

Q: Write a query to copy all columns from Suppliers to Customers.

Answer 7

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
SELECT SupplierName, ContactName, Address, City, PostalCode, Country
FROM Suppliers;

Question 8

Q: Write a query to copy only German suppliers into Customers.

Answer 8

INSERT INTO Customers (CustomerName, City, Country)
SELECT SupplierName, City, Country
FROM Suppliers
WHERE Country = ‘Germany’;