<P> Or on Oracle systems (assuming there is an index on classification. articleID): </P> <Ul> <Li> See Halloween Problem . It is possible for certain kinds of UPDATE statements to become an infinite loop when the WHERE clause and one or more SET clauses may utilize an intertwined index . </Li> <Li> Forgetting to specify the WHERE clause leads for all records to be affected by the update . </Li> </Ul> <Li> See Halloween Problem . It is possible for certain kinds of UPDATE statements to become an infinite loop when the WHERE clause and one or more SET clauses may utilize an intertwined index . </Li> <Li> Forgetting to specify the WHERE clause leads for all records to be affected by the update . </Li>

How to increase column value by 1 in sql