mysql - SQL 身份 phpMyAdmin

Question

我对非常​​简单的事情有一些疑问:IDENTITY。我尝试在 phpMyAdmin 中创建表:

CREATE TABLE IF NOT EXISTS typEventu (
    typEventu_id INT PRIMARY KEY IDENTITY(1,1),
    typ VARCHAR(20),
);

MySQL 返回:

#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 'IDENTITY(1,1) typ VARCHAR(20) )' at line 2

我哪里做错了？

Answer 1

您正在尝试对 MySQL 使用 SQL Server 语法。试试这个:

CREATE TABLE IF NOT EXISTS typEventu (
    typEventu_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    typ VARCHAR(20)
);