We were also going to make the account number column a key. Then add it is a 0 and update it.

As we cannot add two 0's, (not unique) ... we would be locking the table until the update.

Your method is probably more clean. But we could still get two records with the same number?