auto

UK[??:t??] US[??:to?]

n.<US>Automobile

vi. By car

Third person singular: autos Plural: autos Present participle: autoing Past tense: autoed Past participle: autoed

##increment

英[???kr?m?nt ] US [??nkr?m?nt, ???-]

n. Increment; growth; increase; regular salary increase

Plural: increments

mysql AUTO INCREMENT field syntax

Function:Generate a unique number when a new record is inserted into the table

Description:We usually want to automatically generate a unique number every time a new record is inserted into the table. Create the value of the primary key field. We can create an auto-increment field in the table.

mysql AUTO INCREMENT field example

//把 "Persons" 表中的 "P_Id" 列定義為 auto-increment 主鍵
CREATE TABLE Persons(P_Id int NOT NULL AUTO_INCREMENT,LastName varchar(255) NOT NULL,FirstName varchar(255),Address varchar(255),City varchar(255),PRIMARY KEY (P_Id));