Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To do this, we use the following command

Code Block
languagesql
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
languagesql
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.

...