- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to make MySQL table primary key auto increment?
To make MySQL table primary key auto increment, use the below syntax
CREATE TABLE yourTableName ( yourColumnName INT(6) ZEROFILL NOT NULL AUTO_INCREMENT, PRIMARY KEY(yourColumnName) );
Let us first create a table and set primary key auto increment −
mysql> CREATE TABLE DemoTable ( UserId INT(6) ZEROFILL NOT NULL AUTO_INCREMENT, PRIMARY KEY(UserId) ); Query OK, 0 rows affected (0.81 sec)
Insert some records in the table using insert command −
mysql> INSERT INTO DemoTable values(); Query OK, 1 row affected (0.12 sec) mysql> INSERT INTO DemoTable values(); Query OK, 1 row affected (0.13 sec) mysql> INSERT INTO DemoTable values(); Query OK, 1 row affected (0.10 sec) mysql> INSERT INTO DemoTable values(); Query OK, 1 row affected (0.44 sec)
Display all records from the table using select statement −
mysql> select *from DemoTable;
This will produce the following output −
+--------+ | UserId | +--------+ | 000001 | | 000002 | | 000003 | | 000004 | +--------+ 4 rows in set (0.00 sec)
- Related Articles
- Two columns as primary key with auto-increment in MySQL?
- How to insert data to MySQL having auto incremented primary key?
- Set the MySQL primary keys auto increment to be unlimited (or incredibly huge)?
- How to get primary key of a table in MySQL?
- How to identify composite primary key in any MySQL database table?
- How to reset the primary key of a table in mysql?
- How to create a table with auto-increment column in MySQL using JDBC?
- How to auto increment with 1 after deleting data from a MySQL table?
- How to refer primary key as Foreign to various table in MySQL?
- How to change auto increment number in MySQL?
- How can I define a column of a MySQL table PRIMARY KEY without using the PRIMARY KEY keyword?
- ALTER TABLE to add a composite primary key in MySQL?
- How to make a primary key start from 1000?
- Can we remove a primary key from MySQL table?
- Set auto increment initial value for MySQL table using ALTER command

Advertisements