Creating table in MySQL Workbench 6.1

Question

I'm new to MySQL and am trying to create a simple table, but I'm getting the following error:

Error Code: 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 '{ Movie_ID int, Title varchar(60), Genre varchar(30), Director varchar(30), Star' at line 1

Here is my code:

CREATE TABLE Movies {
Movie_ID int,
Title varchar(60),
Genre varchar(30),
Director varchar(30),
Star varchar(30),
ReleaseDate year(),
Grade int,
Rating varchar(5),
};

I tried Googling MySQL 6.1 manual, but couldn't find what I needed.

Dont you mean mysql Workbench 6.1?

Mihai
– Mihai

2014-06-12 00:22:59 +00:00
Commented Jun 12, 2014 at 0:22 — Mihai
– Mihai, Commented Jun 12, 2014 at 0:22

John Conde · Accepted Answer · 2014-06-12 00:28:04Z

1

Table declarations use parenthesis, not brackets:

CREATE TABLE Movies (
    Movie_ID int,
    Title varchar(60),
    Genre varchar(30),
    Director varchar(30),
    Star varchar(30),
    ReleaseDate year(),
    Grade int,
    Rating varchar(5)
);

edited Jun 12, 2014 at 0:28

answered Jun 12, 2014 at 0:19

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

4 Comments

Bryan Over a year ago

Ah Okay thanks. Now it's saying my last line is incorrect. is using ');' not right?

John Conde Over a year ago

Get rid of the last comma after Rating varchar(5)

Bryan Over a year ago

Perfect. Thanks for helping with my stupid mistakes.

Fabricator Over a year ago

@Brett, also I think year() should be changed to year or year(4)

Collectives™ on Stack Overflow

Creating table in MySQL Workbench 6.1

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related