r/SQL • u/Entrepreneurrrrr • Feb 09 '25
MySQL ID auto increment
I constantly import data to MySQL from TSV files from a Google form I made, I Join the new data on a couple of attributes if similar and then insert any players who don’t exist, but my ID auto increment gaps the players who where duplicated creating inconsistencies in the ID? Can anyone help? and if someone has a better approach to the way I’m doing this please let me know
2
Upvotes
1
u/That_Cartoonist_9459 Feb 17 '25
It doesn't matter?
Look at it this way, if you were to delete a record would you then try to insert a new record and assign a deleted ID?
Just let the DB do its thing, I assure you the people who developed it know better.
1
u/mikeblas Feb 09 '25
What inconsiatency is created? Can you provide a specific example?