Bonjour,
j'ai un problem requete sql inser intto voici mon code::
stmt = con.createStatement();
int x= stmt.executeUpdate("INSERT INTO 'enseignant' ('nom_ens' , 'prenom_ens' , 'pass_ens' , 'mail_ens' , 'grade') VALUES ('"+nom+"' , '"+prenom+"' , '"+passe+"' , '"+mail+"' , '"+grade+")'");
voici l'erreur:
com.mysql.jdbc.exceptions.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 ''enseignant' ('nom_ens' , 'prenom_ens' , 'pass_ens' , 'mail_ens' , 'grade') VALU' at line 1
la clé primeire est une auto incremente
s'il vous plait heeeeeeeeeeeeeeelp
et merçi
