MySQL + SQL · Lesson 1

Insert From Another Table

Copying Data

Use INSERT INTO ... SELECT to copy rows from one table into another in a single query.

The Query

-- copy all active users into an archive table
INSERT INTO users_archive (id, name, email)
SELECT id, name, email
FROM users
WHERE status = 'active';

How it Works

The SELECT picks the rows and columns; INSERT INTO places them into the target table. The column order must match.

Summary

  • INSERT INTO target SELECT ... FROM source copies rows directly.
  • Add a WHERE clause to copy only some rows.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.