create a mysql triggers that reorganize the numbering of a field when one of those fields is deleted

Question

create a mysql triggers that reorganize the numbering of a field when one of those fields is deleted

Asked 7 years, 11 months ago

Viewed 37 times

1

I have a table users containing the following column:

note that the position numbering is in order, what I want is when deleting some user to trigger reorganize the numbering, that is to exclude Josefa and Pedro, Jone becomes position 2 and Soares becomes position 3.

Can you explain why you need this? If you use this field only for sorting there is no need to reevaluate the values.

– Genos

2016/12/15 at 12:46
use these fields to perform other operations that need to be in sequence

– Robson Guedes Alves

2016/12/15 at 13:39
could pick up the key from the array, the problem starts with zero

– Robson Guedes Alves

2016/12/15 at 13:42
@Robsonguedesalves uses a rank for that? wouldn’t it be better!

– novic

2016/12/15 at 13:44

1 answer

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.

by Júlio Neto • **1,228** points · Answer 1 · 2016-12-15T13:39:57+00:00

I don’t know how triggers work in Mysql, but in theory, you just need to decrement all the positions below the one you removed, it’s a simple SQL:

update usuarios set posicao = posicao - 1 where posicao < ?

Where "?" is the position of the user that has been removed.