SQL Auto increment Primary Key
SQL Auto increment Primary Key is used to allow a unique number to be generated when a new record is inserted into a table.
Understand with Example
The Tutorial illustrate an elaborative example from 'SQL Auto increment Primary Key'. To understand this example we use a query 'use mysqltutorialabc' that show the database is selected.
 |
Create table employee_roseindia:
The create table employee_roseindia is used to create a table 'employee_roseindia' with required fieldname and data type. The following SQL statement is used to define the "Emp_id" to be an auto-increment primary key field in the table "employee_roseindia".
 |
Show Tables in datebase
Once the table is created ,the show tables shows you the list of tables in database.
 |
Insert into Table :
The insert into adds the records or rows into the table'employee_roseindia'. If we don't insert any values into the primary key column, the auto_increment increment the value by 1 for each new records.
| insert into employee_roseindia values('1','Ranjan','Saurabh','5000');
insert into employee_roseindia values('2','Kumar','Satish','8000'); insert into employee_roseindia values('3','Kumar','Rajesh','10000'); insert into employee_roseindia values(' ','Saxena','Amit','15000'); |
To View the detail of Table employee_RoseIndia:
| select * from employee_roseindia; |
Output is displayed as below :