These functions are connectionspecific, so their return values are not affected by another. If the autoincrement keyword appears after integer primary key, that changes the automatic rowid assignment algorithm to prevent the reuse of. Using uuid for a primary key brings the following advantages uuid values are unique across tables, databases, and even servers that allow you to merge rows from different databases or distribute databases across servers. Sign up auto assign unique attributes for activerecord objects. I need to do a batch insert into a freshly created database. I want to maintain the id assignments from the previous database. You can assign a value returned by a select statement to a userdefined variable, and then refer to the variable later in your mysql session. Why auto increment is a terrible idea clever cloud blog. Read this article to find out how you can auto increment a column in oracle sql. This enables multiplerow inserts to be reproduced correctly on other servers in a replication setup. I have a tblgame in a mysql database, which has two fields. Therefore, i need to temporarily disable auto increment columns and manually assign values. Insert a row, id will be automatically generated insert into airlines name values. The attribute to use when you want mysql to assign a sequence of numbers automatically to a field in essence, creating an autonumber field.