I am trying to use an UPDATE query in MySQL database table. I have primary key that auto increments in the table but I don’t want to use this key when doing this query. This is because this column doesn’t restart its count when records are deleted so there are gaps in the table. For example, if I delete row