Generate SQL INSERT statements that copy existing rows from a table with modified field values.
Useful for duplicating data with slight modifications (e.g., changing status, copying records, etc.)
SQL INSERT SELECT Generator - Copy Rows with Modified Values
This free online SQL generator helps you create INSERT INTO SELECT statements that copy existing rows from a table while modifying specific field values. Perfect for database migration, data duplication, and bulk record updates.
Common Use Cases
- Duplicate user records with different status values
- Copy products to different categories or stores
- Clone database entries for testing environments
- Migrate data between similar table structures
- Create template records from existing data
- Bulk update records by creating new copies
Key Features
- Live SQL Preview - See results as you type
- Field Modification - Change specific column values
- WHERE Clause Support - Filter source records
- ORDER BY & LIMIT - Control result set
- Copy to Clipboard - One-click SQL copy
- Generic Templates - Start with working examples
How It Works
The tool generates a SQL INSERT INTO statement combined with a SELECT query from the same table. You specify which field to modify (e.g., changing 'status' from 'pending' to 'active'), and the generator creates the complete SQL with all your specified conditions.
Example: Copy all pending users to active status, ordered by ID, limited to 10 records. The tool handles the syntax, you focus on the logic.
Perfect for: Database administrators, SQL developers, backend engineers, data analysts, and anyone working with relational databases like MySQL, PostgreSQL, SQLite, MariaDB, or SQL Server.
Keywords: SQL INSERT SELECT, copy table rows, duplicate database records, SQL generator, INSERT INTO SELECT statement, modify field values, bulk data copy, database migration tool, SQL query builder, free online SQL tool