Which is a better db design when inserting records?\[code\]**Option 1.**uid|itemid| qty | price | amount1 |13| 2 | 100 |200**Option 2.**uid| itemid| qty | price | amount1 |13| 1 | 100 | 1002 |13| 1 | 100 | 100\[/code\]In option 2 then retrieve rows via mysql query and calculate using id ...
Mysql Database design structure
- Thread starter kankee
- Start date