By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

update query is updating only a single record, how update all records

P: 1
i am developing an inventry control database, how to update stock when we purchase and sell items, when we purchase new items it should be added to stock, similarly when we sell an item it should be detected from stock. i have written a sql update query which updates only one record, how to update all records
1 Week Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,054

Welcome to Bytes!

Your question is a bit vague.

This all depends upon how youidentify records that need to be updated. Without knowing that, it is impossible to give any greater detail.

How are you updating the one record and what is the criteria you use to update that one record?
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.