How to specify the WHERE clause for UPDATE / DELETE

Sometimes multiple users are accessing the same tables at the same time. In these situations, you need to decide when to allow your application to update the database. If you allow your application to always update the database it could overwrite changes made by other users. You can control when updates succeed by specifying which columns are included in the WHERE clause of an UPDATE or DELETE statement.

Views: 1490 | | by Mark

Report broken link?