MySQL

You can create a column in a table in MySQL and make that column to auto-increment the value every time

This is probably an audit requirement and most of the time it is essential to maintain the creation time. However,

REPLACE is similar to INSERT command. The REPLACE command behaves as INSERT when there is no record matching the constraints.

Imagine that you have already fetched a few hundreds records matching certain criteria. Now, all that you need is the