Page History
...
To do this, we use the following command
| Code Block | ||
|---|---|---|
| ||
Update ldap_server_connection set ldap_server_connections_idx = ldap_server_connections_idx – 1 where ldap_server_connections_idx > # |
(replacing the # with the index number that has been deleted)
So for my example index number 2 has been deleted, so I type in
| Code Block | ||
|---|---|---|
| ||
Update ldap_server_connection set ldap_server_connections_idx = ldap_server_connections_idx – 1 where ldap_server_connections_idx > 2; |
And then if we run the select * from command again you can see the index numbers are back in order.
...