mySQL table creation query syntax error

Question

// Please can anyone tell me what is wrong with this MySQL query syntax ?

String createTableSQL = ""
                + " CREATE TABLE location("
                + " location_id INTEGER PRIMARY KEY AUTOINCREMENT,"
                + " location_name VARCHAR(30),"
                + " addr VARCHAR(30),"
                + ")";

ScaisEdge · Accepted Answer · 2016-08-25 06:22:14Z

1

remove the last change AUTOINCREMENT in AUTO_INCREMENT and add PRIMARY KEY (location_id)

 String createTableSQL = ""
            + " CREATE TABLE location("
            + " location_id INTEGER PRIMARY KEY AUTO_INCREMENT,"
            + " location_name VARCHAR(30),"
            + " addr VARCHAR(30),"
            + " PRIMARY KEY (`location_id `))";

edited Aug 25, 2016 at 6:22

answered Aug 24, 2016 at 18:45

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

2 Comments

Marta Ginosian Over a year ago

I removed , maybe I have few mistakes so it didn't help at this time.

Marta Ginosian Over a year ago

Great, thank you @Mike. It helped, table is created.

Collectives™ on Stack Overflow

mySQL table creation query syntax error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related