Insert From Another Table

Copying Data

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

Summary

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

Data Copy करना

Query

-- सभी active users को archive table में copy करें
INSERT INTO users_archive (id, name, email)
SELECT id, name, email
FROM users
WHERE status = 'active';

कैसे काम करता है

सारांश

• INSERT INTO target SELECT ... FROM source rows सीधे copy करता है।
• कुछ ही rows copy करने को WHERE clause जोड़ें।