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