VB.NET - mysql query - Asked By pradeep kumar on 27-Nov-13 11:12 PM

how to write the query,example like this
itemid    purchaseditem   totalpurchaseditem

124        10             10

456        30             40


678        50             90


in this example insert the item every time automatically add and shows the totalpurchased item