13. Modify the auto-increment primary key and Character Set

The following content is excerpted from [1-2]

1. Auto-increment primary key

SQL statements with auto-increment primary keys in MySQL database tables

1) do not control the start point of the primary key

Create Table emb_t_dictbustype

(

Emb_c_bustypeid int not null auto_increment,

Emb_c_bustypeenname varchar (255) not null,

Emb_c_bustypezhname varchar (255) not null,

Primary Key (emb_c_bustypeid)

) Engine = InnoDB default charset = GBK;

2) control the start point of the primary key

Create Table emb_t_dictbustype

(

Emb_c_bustypeid int not null auto_increment,

Emb_c_bustypeenname varchar (255) not null,

Emb_c_bustypezhname varchar (255) not null,

Primary Key (emb_c_bustypeid)

) Engine = InnoDB auto_increment = 1001 default charset = GBK;

Original article:

[1] MySQL primary key auto-Increment

Http://www.2cto.com/database/201202/118580.html

[2] modifying the character set of databases and tables, two types of primary keys

Http://blog.csdn.net/arkblue/article/details/4140061