Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Nov 15, 2017

Making a Column Autoincrement the Value Itself in MySQL

You can create a column in a table in MySQL and make that column to auto-increment the value every time a record is inserted in the table.

The catch is that you need to ensure that the column you are trying to auto-increment should also be a key column.

Sample table

CREATE TABLE `Details` (
   `ai` INT(11) NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(50) NULL DEFAULT NULL ,
   `address` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_bin',
   PRIMARY KEY (`ai`)
)
COLLATE='utf8_bin'
ENGINE=InnoDB;

Please note that the column ai is also the PRIMARY KEY and hence AUTO_INCREMENT is allowed.

M S Sridhar
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date