I have available_quantity
column in mobiles
table and available quantity is 2.
And I have quantity
in stock
table. This quantity is 7.
Now what is the SQL command for updating the available_quantity
column? Means after updating available_quantity
have to show 9.