Making A Record Unique By Incrementing A Number In Javascript

I wanted to increment a number to a filename if the filename already exists in the database (based on the records too). for example if I add file with filename DOC it will check if

Solution 1:

#suggetion

Your logic could break ACID rules in my view you could try adding an numberOfFiles column instead and use update sql query like update set numberOfFiles = numberOfFiles + 1 where yourTable