mysql - 创建 MySQL 表的语法错误

Question

也许我对 Postgres 太习惯了，但为什么会出现此错误

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 '{ id int not null AUTO_INCREMENT, email varchar(100) not null, primary key(id' at line 1

我什么时候运行这个？

create table `users`{
    id int not null AUTO_INCREMENT,
    email varchar(100) not null,
    primary key(id)
};

Answer 1

使用圆括号(普通括号)() 而不是大括号:

create table `users` (
    id int not null AUTO_INCREMENT,
    email varchar(100) not null,
    primary key(id)
);