title: SQL Insert into Only Certain Columns
body: <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>