Yes, it is very simple, all you need to do is insert a row into your table with the value 234097 explicitly stated in your auto incrementing column, and then delete the row. When you insert that row, it will update the last_insert_id value to 234097. The next time you insert a null value into that column, it will replace the null with last_insert_id + 1 and then update last_insert_id, so it should start counting up from 234098 as you requested.