Top "Auto-increment" questions

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

How to get last inserted row ID from WordPress database?

My WordPress plugin has a table with a AUTO_INCREMENT primary key field called ID. When a new row is …

wordpress auto-increment race-condition
How to add AUTO_INCREMENT to an existing column?

How do I add auto_increment to an existing column of a MySQL table?

mysql auto-increment
SQL Server, How to set auto increment after creating a table without data loss?

I have a table table1 in SQL server 2008 and it has records in it. I want the primary key table1_…

sql-server sql-server-2008 identity auto-increment
Auto increment in MongoDB to store sequence of Unique User ID

I am making a analytics system, the API call would provide a Unique User ID, but it's not in sequence …

mongodb auto-increment uniqueidentifier bitset bitarray
Create autoincrement key in Java DB using NetBeans IDE

I'm coming from MySQL world, please help. Is it possible to create autoincrement key from NetBeans IDE in JavaDB? Do …

netbeans auto-increment javadb
How to retrieve the last autoincremented ID from a SQLite table?

I have a table Messages with columns ID (primary key, autoincrement) and Content (text). I have a table Users with …

database sqlite primary-key auto-increment junction-table
MSSQL Select statement with incremental integer column... not from a table

I need, if possible, a t-sql query that, returning the values from an arbitrary table, also returns a incremental integer …

sql sql-server sql-server-2000 auto-increment row-number
How can I avoid getting this MySQL error Incorrect column specifier for column COLUMN NAME?

How can I avoid getting this MySQL error Incorrect column specifier for column topic_id ? MySQL Error... #1063 - Incorrect column …

mysql sql auto-increment ddl
How to insert new row to database with AUTO_INCREMENT column without specifying column names?

I have a table with the following columns: id - INT UNSIGNED AUTO_INCREMENT name - VARCHAR(20) group - VARCHAR(20) …

sql mysql insert auto-increment
auto increment ID in H2 database

Is there a way to have an auto_incrementing BIGINT ID for a table. It can be defined like so …

database auto-increment h2