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))
设置索引