In this article, we will find out about the auto increase function of SQL and afterward the procedure to include it our primary key.
Primary keys are significant in light of the fact that they have one of a kind records which at that point used to distinguish the records in the table. Be that as it may, how would we know which the one of a kind value is and which isn’t?
There is no simple way we can foresee the following exceptional value without glancing in the database. Along these lines, this brings an extraordinary idea which let the database handles the value of a primary key.
The database monitors the greatest value our key has reached previously and it generally increases that value by 1. At the point when we let the database handles the key, we should give any value for that field when we embed a record.
Presently to make a primary key AUTO_INCREMENT, we must have a field which has the datatype with number juggling abilities. Without a doubt, varchar isn’t that datatype.
On the off chance that we got this thing all together, at that point simply ALTER the table and MODIFY the section.
Table (worker) having three fields and four information in it,
Id Name Address
100 Aman Mumbai
200 Arun Pune
300 Karan Delhi
400 Aman MumbaiAbove table got three sections and one of them (id) is our primary key and now we simply need to make an adjust table inquiry with alter segment and afterward give the segment name on which we have to include auto increase after that simply include AUTO_INCREMENT in it.
Query:
ALTER TABLE employee MODIFY COLUMN 'id' INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
Output:
