SQL Insert into Only Certain Columns
<p>I have a database with 5 columns. The first column is the ID which will be automatically incremented everytime a new row is added using this statement.</p>

<pre><code>ALTER TABLE help MODIFY COLUMN id INT auto_increment
</code></pre>

<p>So, because this will automatically increment I dont want to set it as anything, because of this I thought of this statement. However, it leaves a syntax error. Any ideas why?</p>

<pre><code>   String update = "INSERT INTO help(" + name + ", " + area + ", " + date + ", " + message + ") VALUES(?, ?, ?, ?)";
        try {
            connection = plugin.getHikari().getConnection();
            // Inserting into the table
            statement = connection.prepareStatement(update);
            // Replace the '?' with the actual information
            statement.setString(1, name);
            statement.setString(2, area);
            statement.setString(3, date);
            statement.setString(4, message);
            statement.execute();
        } catch (SQLException e) {
            e.printStackTrace();
        }
</code></pre>

<p>Thanks, 
- Nicster</p>

<p>PS: Yes, this is day 2 of my SQL adventure D:</p>