Databases Reference
In-Depth Information
Duplicating rows of data
During the course of data maintenance (for permanent duplication or for test
purposes), we often have to generate a copy of a row. If this is done in the same
table, we must respect the rules of key uniqueness.
Here is an example of row duplication. Our author has written volume 2 of his book
about cinema. Hence, the columns that need a slight change are the ISBN, title, and
page count. We bring the existing row on screen, change these three columns, and
choose
Insert
as
new
row
, as shown in the following screenshot:
Search WWH ::
Custom Search