Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Inserting selected rows

Make it work

Report a typo

Correct the query that should copy all data from the table chairs (chair_name VARCHAR(20), inventory_number INT) to the table furniture (product_name VARCHAR(20), inventory_number INT).

INSERT INTO chairs (chair_name, inventory_number) 
inventory_number, product_name FROM furniture
Write an SQL statement





___

Create a free account to access the full topic