MySQL Syntax Error while creating a table - Java

Question

I have never used mysql before so this is my first attempt. The syntax/coding im using...

"CREATE pets (" 
                + "uuid INT NOT NULL,"  
                + "type VARCHAR(100) NOT NULL," 
                + "name VARCHAR(100) NOT NULL,"  
                + "health INT NOT NULL,"
                + "badge VARCHAR(40),"
                + ")"

And the error is

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 'pets (uuid INT NOT NULL,type VARCHAR(100) NOT NULL,name VARCHAR(100) NOT NULL,he' at line 1

CREATE TABLE pets...

rgettman
– rgettman

2014-03-21 22:24:57 +00:00
Commented Mar 21, 2014 at 22:24 — rgettman
– rgettman, Commented Mar 21, 2014 at 22:24

juergen d · Accepted Answer · 2014-03-21 22:32:16Z

3

Add table to the first line

"CREATE table pets ("

Remove the comma at the end of this line

+ "badge VARCHAR(40),"
                    ^------here

Generally if you look at the error message you see the first problematic point right after for the right syntax to use near

edited Mar 21, 2014 at 22:32

answered Mar 21, 2014 at 22:24

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Comment

user3448331 Over a year ago

I removed it and still getting the same error. I want a table with uuid as the int id and then type, name and badge as a string and health as a int @juergen-d EDIT: Didn't have table let me try that

Collectives™ on Stack Overflow

MySQL Syntax Error while creating a table - Java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related