java - 为什么会出现 "MySQLSyntaxErrorException:"错误？

Question

语法错误，我好像找不到。我是数据库的新手。

错误:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'database ( ID INTEGER NOT NULL, QUESTION varchar(100) NOT NULL, ANSWER varchar(5' at line 1

代码:

public void createTable(Connection conn) {
    try {
        String createString = "CREATE TABLE " + this.tableName + " ( "
                + "ID INTEGER NOT NULL, "
                + "QUESTION varchar(100) NOT NULL, "
                + "ANSWER varchar(500) NOT NULL, " + "PRIMARY KEY (ID))";

        this.sendUpdate(conn, createString); //This part definitely works as intended
        System.out.println("Created a table called " + this.tableName);
    } catch (SQLException e) {
        System.out.println("ERROR: Could not create the table");
        e.printStackTrace();
        return;
    }
}

Answer 1

DATABASE 是一个 MySQL reserved word .为表使用不同的名称