MySQL自增长列，设置主键和索引

CREATE TEMPORARY TABLE user_quantity_tmp (USER_ID VARCHAR(32) NOT NULL,MAX_QUANTITY INTEGER NOT NULL,TMP_ID INT(5) NOT NULL AUTO_INCREMENT,PRIMARY KEY (TMP_ID),                  INDEX user_quantity_tmp _index (TMP_ID(32)));

TMP_ID INT(5) NOT NULL AUTO_INCREMENT,

创建自增长列

PRIMARY KEY (TMP_ID), 

设置主键

INDEX user_quantity_tmp _index (TMP_ID(32))

设置索引