mysql> SELECT TrackID FROM JourneyTracks; +---------+ | TrackID | +---------+ | 43 | | 44 | | 45 | | 46 | | 47 | | 48 | | 49 | | 50 | | 51 | | 52 | | 53 | | 54 | | 55 | | 56 | | 57 | | 58 | | 59 | | 60 | | 61 | | 62 | | 63 | | 64 | | 65 | | 66 | | 67 | | 68 | | 69 | | 70 | | 71 | | 72 | | 73 | | 74 | | 75 | | 76 | | 77 | | 78 | | 79 | | 81 | | 82 | | 83 | | 84 | | 85 | | 86 | | 88 | | 90 | | 91 | | 92 | | 93 | | 94 | | 95 | | 96 | | 97 | | 98 | | 99 | | 100 | | 101 | | 102 | | 2508 | | 2509 | | 2510 | | 2511 | | 2512 | | 2513 | | 2514 | | 2515 | | 2516 | | 2517 | | 2518 | | 2519 | | 2520 | | 2521 | +---------+ difference 2405 mysql> UPDATE JourneyTracks SET TrackID=TrackID-2405 WHERE TrackID > 103; Query OK, 14 rows affected (0.01 sec) Rows matched: 14 Changed: 14 Warnings: 0 mysql> UPDATE JourneySegments SET TrackID=TrackID-2405 WHERE TrackID > 103; Query OK, 14 rows affected (0.01 sec) Rows matched: 14 Changed: 14 Warnings: 0 mysql> ALTER TABLE JourneyTracks AUTO_INCREMENT=117;