Removing row in MySQL DB with java

Question

I'm trying to remove a row based on the id but i keep getting a NullPointerException.

My code:

public void removePatientsFromDatabase(int id) {
    String removeSql = "DELETE FROM patienten WHERE idPatient id = idn";
    try (Connection con = sql2o.open()) {
        con.createQuery(removeSql)
                .addParameter("idn", id)
                .executeUpdate();
    }
}

The error:

The database:

Answer 1

you need add : before your parameter. Try:

DELETE FROM patienten WHERE idPatient= :idn