Community Member Profile
Alqin
Member since Jul 16, 2010
- Profile: /members/6429-Alqin.htm
- Comments: 2
- Points: 21
Recent Blog Comments By Alqin
-
Using CASE Statements In A SQL UPDATE Query
Posted on Jul 18, 2010 at 4:04 PM
@Ben, I'm playing around with a custom autoincrement. For example if I delete all entries from mammal category, and there were like 5, when I insert new row the increment has to start from 6. So... To remember the last incremented value, I thought that something like DELETE... read more »
-
Using CASE Statements In A SQL UPDATE Query
Posted on Jul 16, 2010 at 2:34 PM
What about if i only want to update on true ignoring the else? CASE WHEN 1>0 THEN UPDATE table field='true' WHERE field='false' END;... read more »
