Top "Auto-increment" questions

a database constraint that automatically increases from the last record when making an INSERT

How do I change the Auto Increment counter in MySQL?

I have an ID field that is my primary key and is just an int field. I have less than 300 …

mysql auto-increment
What is the biggest ID number that autoincrement can produce in mysql

I have an database that is rapidly filled with data we talk about 10-20k rows per day. What is …

mysql database integer auto-increment
Autonumber with Entity Framework

I want to loop through a collection of objects and add them all to a table. The destination table has …

c# entity-framework exception auto-increment
Autoincrement uniqueidentifier

Basically I want to use uniqueidentifier in similar way as identity. I don't want to insert values into it, It …

sql-server database uniqueidentifier auto-increment
SQL - Check if a column auto increments

I am trying to run a query to check if a column auto increments. I can check type, default value, …

mysql sql sql-server auto-increment
MySQL insert into table with auto-increment while selecting from another table

I have a table with an auto-increment primary key: create table rt_table ( rtID int PRIMARY KEY AUTO_INCREMENT, rt_…

mysql select insert auto-increment
Mapping PostgreSQL serial type with Hibernate annotations

I am using Hibernate 3.3 and PostgreSQL 8.x and would like to use Hibernate annotations to map an auto-incremented column which …

hibernate postgresql sequence auto-increment
MySQL AUTO_INCREMENT does not ROLLBACK

I'm using MySQL's AUTO_INCREMENT field and InnoDB to support transactions. I noticed when I rollback the transaction, the AUTO_…

mysql transactions innodb auto-increment
Create unique autoincrement field with mongoose

Given a Schema: var EventSchema = new Schema({ id: { // ... }, name: { type: String }, }); I want to make id unique and autoincrement. I …

node.js mongodb mongoose auto-increment database
Auto-increment in Oracle without using a trigger

What are the other ways of achieving auto-increment in oracle other than use of triggers?

oracle triggers auto-increment sequences