auto-increment Archives

How to add an auto-incrementing primary key to an existing table, in PostgreSQL?

I have a table with existing data. Is there a way to add a primary key without deleting and re-creating the table? 5 … Read more

I’m new at postgres (and at database info systems all in all). I ran following sql script on my database: create table cities … Read more

I have a table in PostgreSQL with many columns, and I want to add an auto increment primary key. I tried to create … Read more

I’ve deleted some records from a table in a SQL Server database. The IDs in the table look like this: 99 100 101 … Read more

I would like to force the auto increment field of a table to some value, I tried with this: ALTER TABLE product AUTO_INCREMENT … Read more

How do I get the current AUTO_INCREMENT value for a table in MySQL? 9 Answers 9

Let’s say I am doing a MySQL INSERT into one of my tables and the table has the column item_id which is set … Read more

How do I set the initial value for an “id” column in a MySQL table that start from 1001? I want to do … Read more

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can I create a column … Read more

I’m switching from MySQL to PostgreSQL and was wondering how I can do autoincrement values. I saw in the PostgreSQL docs a datatype … Read more