insert command increment one even not inserted due to duplicate values September 6, 2022 in Tips and Tricks Prevent auto increment on MySQL duplicate insert