By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 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
Mar 11 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,284

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?
Mar 11 '19 #2

Post your reply

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