mySQL建表查询语法错误

Question

//谁能告诉我这个 MySQL 查询语法有什么问题？

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

Answer 1

去掉AUTO_INCREMENT中的最后一个变化AUTOINCREMENT并添加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 `))";