Syntax error creating MySQL table

Question

Perhaps I'm just too used to Postgres but why am I getting this error

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

when I run this?

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

Use parentheses CREATE TABLE Users ( ... ) not braces CREATE TABLE Users { ... }. — Dour High Arch
– Dour High Arch, Commented Apr 4, 2014 at 21:10

Stewart · Accepted Answer · 2014-04-04 21:11:10Z

2

Use parenthesis (normal brackets) () not braces:

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

answered Apr 4, 2014 at 21:11

Stewart

18.8k10 gold badges60 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

N.Be · Accepted Answer · 2014-04-04 22:30:06Z

1

the correct syntax is :

CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
email VARCHAR(100) NOT NULL,
PRIMARY KEY(id) );

check it out here for your version:

https://dev.mysql.com/doc/refman/4.1/en/creating-tables.html

answered Apr 4, 2014 at 22:30

N.Be

387 bronze badges

Collectives™ on Stack Overflow

Syntax error creating MySQL table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related