CREATE TABLE ' ecm_address ' (' addr_id ' int (ten) unsigned NOT null auto_increment, ' user_id ' int (ten) unsigned NOT NULL Defau LT ' 0 ', ' consignee ' varchar ($) NOT null default ' ', ' region_id ' int (ten) unsigned DEFAULT NULL, ' region_name ' varchar (255) Default NULL, ' address ' varchar (255) default NULL, ' zipcode ' varchar ' default ' null ', ' phone_tel ' varchar ' default NU ' LL, ' phone_mob ' varchar DEFAULT NULL, PRIMARY key (' addr_id '), key ' user_id ' (' user_id ')) Engine=myisam auto_increment =2 DEFAULT Charset=utf8 You notice the MySQL statement that created the table, in the last line there is a: auto_increment=2, this indicates that after the table is built, autogrow is starting from 2, if = 10, then starting from 10. Understand, useful words, please give points, thank you!
MySQL primary key self-growth and set default value