Mysql syntax error - MySQL Workbench

Question

The syntax looks ok to me - but MySQL workbench complains about the last line:

Field20 VARCHAR(120);

The code being executed is as below:

CREATE TABLE Documents(
DocumentID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(DocumentID),
Field1 VARCHAR(120),
Field2 VARCHAR(120),
Field3 VARCHAR(120),
Field4 VARCHAR(120),
Field5 VARCHAR(120),
Field6 VARCHAR(120),
Field7 VARCHAR(120),
Field8 VARCHAR(120),
Field9 VARCHAR(120),
Field10 VARCHAR(120),
Field11 VARCHAR(120),
Field12 VARCHAR(120),
Field13 VARCHAR(120),
Field14 VARCHAR(120),
Field15 VARCHAR(120),
Field16 VARCHAR(120),
Field17 VARCHAR(120),
Field18 VARCHAR(120),
Field19 VARCHAR(120),
Field20 VARCHAR(120);

Sergey Kalinichenko · Accepted Answer · 2012-08-26 11:20:54Z

4

You are missing a closing parenthesis at the end of the statement, after the last field:

...
Field18 VARCHAR(120),
Field19 VARCHAR(120),
Field20 VARCHAR(120)
); --- HERE

answered Aug 26, 2012 at 11:20

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

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

Comments

mewm · Accepted Answer · 2012-08-26 11:21:22Z

0

You forgot the last paranthesis:

CREATE TABLE Documents(
DocumentID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(DocumentID),
Field1 VARCHAR(120),
Field2 VARCHAR(120),
Field3 VARCHAR(120),
Field4 VARCHAR(120),
Field5 VARCHAR(120),
Field6 VARCHAR(120),
Field7 VARCHAR(120),
Field8 VARCHAR(120),
Field9 VARCHAR(120),
Field10 VARCHAR(120),
Field11 VARCHAR(120),
Field12 VARCHAR(120),
Field13 VARCHAR(120),
Field14 VARCHAR(120),
Field15 VARCHAR(120),
Field16 VARCHAR(120),
Field17 VARCHAR(120),
Field18 VARCHAR(120),
Field19 VARCHAR(120),
Field20 VARCHAR(120));

answered Aug 26, 2012 at 11:21

mewm

1,27710 silver badges13 bronze badges

Collectives™ on Stack Overflow

Mysql syntax error - MySQL Workbench

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related