How to get multiple row from database

Question

How to get multiple row from database and Some changes to store another table

 

Ex: Table 1 

 

No	Name	Qty	Price
AA-1	Nokia	1	1000
AA-1	HTC	1	1000
AA-1	Samsung	2	2500

 

     get the rows from  Table 1  and change Id-No to store another table Table2 

 

 EX: Table 2

ID	Name	Qty	Price
M-2	Nokia	1	1000
M-2	HTC	1	1000
M-2	Samsung	2	2500

 

how to implement the process