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))

设置索引