How to easily copy table rows using only SQL queries

To easily copy table rows using only queries, you need to create temporary table, copy rows to this table from from table where you want to copy rows, optionally change some values and put them back to table where you want to have copied rows.

How to do this using queries

  1. Create new temporary table and put to them rows which you want to copy
  2. Now you can change some values in these rows
  3. Put rows back to table where you want to have copied rows
  4. Remove temporary table

I ask you to review this article

Rating 5 Stars from 1 reviews

Leave a Reply

Your email address will not be published. Required fields are marked *

4 × two =