MySQL: How to copy rows, but change a few fields?

by 
INSERT INTO Table
          ( Event_ID
          , col2
           ...
          )
     SELECT "155"
          , col2
           ...
      FROM Table WHERE Event_ID = "120"

Here, the col2, … represent the remaining columns (the ones other than Event_ID) in your table.

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. How to SELECT the newest four items per category?
  3. MySQL: Alternatives to ORDER BY RAND()
  4. Simple way to calculate median with MySQL
  5. MySQL LIKE IN()?
  6. Auto Increment after delete in MySQL
  7. In MySQL queries, why use join instead of where?
  8. MySQL “NOT IN” query
  9. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  10. Stored Procedure with optional “WHERE” parameters
  11. SQLite – ORDER BY RAND()
  12. MySQL syntax for Join Update
  13. How to search multiple columns in MySQL?
  14. MySQL – Selecting data from multiple tables all with same structure but different data
  15. Can a stored procedure/function return a table?
  16. SQL SELECT to get the first N positive integers
  17. Sorting string column containing numbers in SQL?
  18. Error: The used SELECT statements have a different number of columns
  19. How to Optimize Queries in a Database – The Basics
  20. Multiple Ranks in one table
  21. Any way to achieve fulltext-like search on InnoDB
  22. The difference between ‘AND’ and ‘&&’ in SQL
  23. How can I make an average of dates in MySQL?
  24. How to combine aggregate functions in MySQL?
  25. What is the best way to generate ranks in MYSQL?
  26. How important are lookup tables?
  27. How to find all IDs of children recursively?
  28. how to use LIKE with column name
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment