CREATE TABLE trucks ( Id int(11) NOT NULL AUTO_INCREMENT, Name varchar(45) NOT NULL, Type varchar(45) NOT NULL, PlateNumber varchar(15) NOT NULL, PRIMARY KEY (Id), UNIQUE KEY Id_UNIQUE (Id) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
Refer this
CREATE TABLE trucks ( Id int IDENTITY(1,1) NOT NULL, Name varchar(45) NOT NULL, Type varchar(45) NOT NULL, PlateNumber varchar(15) NOT NULL, PRIMARY KEY (Id), CONSTRAINT AK_TransactionID UNIQUE(Id) )
For setting the Auto increamet to start with some other value than 1
Refer
http://www.blackwasp.co.uk/ResetSqlServerIdentity.aspx
http://stackoverflow.com/questions/1280705/set-start-value-for-column-with-autoincrement
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.