SQL: Using a CASE Statement to update 1000 rows at once
- by SoLoGHoST
Ok, I would like to use a CASE STATEMENT for this, but I am lost with this. Basically, I need to update a ton of rows, but just on the "position" column. I need to update all "position" values from 0 - count(position) for each id_layout_position column per id_layout column.
OK, here is a pic of what the table looks like:
Now let's say I delete…