Im trying to insert variable value into my database. But I cant seem to do it. I am using java language. Below is my intended SQL statement . score is my variable i want to input to database.
SQL = "INSERT INTO lettergame (Nickname,Difficulty,Score,TimeElapsed) VALUES ('Keong','Extreme', '" & score & "','03:45:22')"; stmt = con.createStatement(); rs = stmt.executeQuery(SQL);
Help is appreciated