临时表中的自动增量 [英] Auto Increment in Temporary Table

问题描述

我正在尝试创建一个临时表，该表具有一个自动递增的键字段.但是我一直遇到语法错误.

I'm trying to create a Temp Table that has a key field that auto increments. But I keep running into a syntax error.

这就是我要尝试的:

CREATE TEMPORARY TABLE
    RETURN_ARTISTS
        (KEY INT(11) NOT NULL AUTO_INCREMENT,
        ARTIST_1_KEY INT(11),
        ARTIST_2_KEY INT(11));

INSERT INTO RETURN_ARTISTS (1,1);

DELETE TABLE RETURN_ARTISTS;

这是我不断得到的错误:

And here's the error I keep getting:

Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT(11) NOT NULL AUTO_INCREMENT,
        ARTIST_1_KEY INT(11),
        ARTIST_2_KEY INT(' at line 3

推荐答案

首先，key是保留字，用`

第二，当使用auto_increment列时，必须将该列定义为键.

Secondly, when using auto_increment column, that column must be defined as a key.

CREATE TEMPORARY TABLE
`RETURN_ARTISTS`
    (`KEY` INT(11) NOT NULL AUTO_INCREMENT,
    ARTIST_1_KEY INT(11),
    ARTIST_2_KEY INT(11),
    KEY (`KEY`));

这篇关于临时表中的自动增量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！