Carlos kambui

Carlos kambui

  • NA
  • 499
  • 125.6k

sharing Codes in sql database

Feb 11 2017 5:35 AM
i have table location_stock with column product_id,product_name,product_code,product_scancode
dataa are like follows
1 ,test,0001,0001
2,test2,0002,0002
3,test3,0003,0003
problem is product_code number 0001,is sold always and product_code 0002,now i came to see that product_code 0003 when i came to select has changed the code itself to 0001 once i select 0001 and 0003 ,0001 and quantity to 2 ,help me to solve this  

Answers (3)