What is the difference between INSERT ... SELECT and INSERT ... VALUES?

SQL changing data safely · Freshers

Model answer

VALUES inserts literal rows you write. INSERT ... SELECT inserts the result of a query, which is how you copy or transform data between tables in one statement.

Learn this topic

INSERT, UPDATE and DELETE: Change Data Safely in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions