CODEWITHSUNDEEP
mysqlsyntax
Marta Ginosian
Marta Ginosian

Reputation: 117

mySQL table creation query syntax error

// 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),"
                + ")";

Upvotes: 1

Views: 28

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133360

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 `))";

Upvotes: 1

Related Questions