Top "Auto-increment" questions

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

Mysql - Add auto_increment to primary key

I have a strange problem with mysql. I am trying to alter a table's column which is a primary key …

mysql database foreign-keys auto-increment
SQLite autoincrement - How to insert values?

I generate a SQLite table (in java): create table participants (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, col1,col2); afterwards I try …

java sqlite auto-increment
How does autoIncrement work in NodeJs's Sequelize?

Sequelize's document doesn't say a whole lot about autoIncrement. It only includes the following example: // autoIncrement can be used to …

node.js postgresql-9.1 auto-increment sequelize.js
What happens when auto_increment on integer column reaches the max_value in databases?

I am implementing a database application and I will use both JavaDB and MySQL as database. I have an ID …

database auto-increment integer-overflow lastinsertid
How to autoincrement versionCode in Android Gradle

I'm experimenting with new Android build system based on Gradle and I'm thinking, what is the best way to autoincrease …

android build android-manifest gradle auto-increment
How to Reset an MySQL AutoIncrement using a MAX value from another table?

I know this won't work, tried it in various forms and failed all times. What is the simplest way to …

sql mysql auto-increment reset
mysqldump - Export structure only without autoincrement

I have a MySQL database and I am trying to find a way to export its structure only, without the …

mysql export mysqldump database-schema auto-increment
I need to auto_increment a field in MySQL that is not primary key

Right now, I have a table whose primary key is an auto_increment field. However, I need to set the …

mysql primary-key auto-increment
Prevent auto increment on MySQL duplicate insert

Using MySQL 5.1.49, I'm trying to implement a tagging system the problem I have is with a table with two columns: …

mysql insert duplicates innodb auto-increment
PHP MYSQL - Insert into without using column names but with autoincrement field

I need to insert a long row with 32 fields into a MySQL table. I'd like to do something like this: $…

php mysql auto-increment