CREATE TABLE Persons( P_Id int NOT NULL AUTO_INCREMENT=100, LastName varchar(255) NOT NULL);
When trying to enter NULL value for P_Id then 100 will be placed there.
P_Id value starts from 1 and then it is auto incremented by value 1 upto 100.
Generates error as there is no constraint like "AUTO_GENERATE".
P_Id value starts from 100 and then it is auto incremented by value 1.