Mysql primary key auto-increment and default value, mysql Default Value

Mysql primary key auto-increment and default value, mysql Default Value

Create table 'ecm _ address' ('addr _ id' int (10) unsigned not null AUTO_INCREMENT, 'user _ id' int (10) unsigned not null default '0 ', 'consignee' varchar (60) not null default '', 'region _ id' int (10) unsigned default null, 'region _ name' varchar (255) default null, 'address' varchar (255) default null, 'zipcode' varchar (20) default null, 'phone _ tel 'varchar (60) default null, 'Phone _ mob' varchar (60) DEFAULT NULL, primary key ('addr _ id'), KEY 'user _ id' ('user _ id ')) ENGINE = MyISAM AUTO_INCREMENT = 2 default charset = utf8 pay attention to the mysql statement used to create the table. In the last row, there is AUTO_INCREMENT = 2, which indicates that after the table is created, automatic growth starts from 2. If it is equal to 10, it starts from 10. Thank you!