INSERT INTO…SELECT for all MySQL columns

by

The correct syntax is described in the manual. Try this:

INSERT INTO this_table_archive (col1, col2, ..., coln)
SELECT col1, col2, ..., coln
FROM this_table
WHERE entry_date < '2011-01-01 00:00:00';

If the id columns is an auto-increment column and you already have some data in both tables then in some cases you may want to omit the id from the column list and generate new ids instead to avoid insert an id that already exists in the original table. If your target table is empty then this won’t be an issue.

More Related Contents:

  1. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  2. Recreating a query using INNER JOIN? [duplicate]
  3. MySQL – UPDATE query based on SELECT Query
  4. quick selection of a random row from a large table in mysql
  5. MySQL: is a SELECT statement case sensitive?
  6. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  7. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  8. MySQL Query – Records between Today and Last 30 Days
  9. Ordering by specific field value first
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. Combine Multiple child rows into one row MYSQL
  12. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  13. How to get an age from a D.O.B field in MySQL?
  14. MySQL difference between two rows of a SELECT Statement
  15. MySQL – How to search for exact word match using LIKE?
  16. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  17. How do I get the first day of the week of a date in mysql?
  18. MySQL error 1241: Operand should contain 1 column(s)
  19. quick selection of a random row from a large table in mysql
  20. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  21. mysql select sum group by date
  22. SELECT query return 1 row from each group
  23. MySQL – SQL_BIG_SELECTS
  24. Comma separated string of selected values in MySQL
  25. MySQL Select Query – Get only first 10 characters of a value
  26. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  27. MySQL Error: #1142 – SELECT command denied to user
  28. How to use Table output from stored MYSQL Procedure
  29. MySQL cartesian product between two SELECT statements
  30. MySQL Select Multiple VALUES

Leave a Comment