Hi Everyone, I'm newbie with MySQL with some programming experience. I'm about to implement an Internet shop. I would like to serve my customers at a high level with, amongst other features, making sure that every successful order will really be shipped due to a stock availability check at order taking. The database related steps I am planning to use are: 1. checking stock of item X (select) 2. recording order (insert) 3. modifying stock if item X (update)
With not using transaction or lock tables the available stock can be changed by others between Step 1 and 2 or Step 2 and 3. Which solution supports better such a scenario in MySQL? Which is used by you? Thank you for your help. Regards, Tibor --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php