hi sir i m having problem in updating the record . i m trying the query to update .but it is giving me the " Syntax error problem" Code: //stmt.executeUpdate("UPDATE StdInfo SET(STD_GR='"+gr+"', Name='"+name+"', Fname='"+fname+"', Surname='"+sname+"', Guardian-Name='"+gname+"', Religion='"+rel+"',Age='"+age+"',Date-of-Birth='"+dd+"',Month-of-Birth='"+mon+"',Year-of-Birth='"+year+"',Birth-Place='"+birthplace+"',Birth-District='"+bitrhdistrict+"',Country='"+country+"',Temp-Address='"+add+"',Perm-Address='"+padd+"',Phone='"+phone+"',Password='"+password+"') where STD_GR='"+gr+"'"); 2nd Code: stmt.executeUpdate("insert into StdInfo values('"+gr+"','"+name+"','"+fname+"','"+sname+"','"+gname+"','"+rel+"','"+age+"','"+dd+"','"+mon+"','"+year+"','"+birthplace+"','"+bitrhdistrict+"','"+country+"','"+add+"','"+padd+"','"+phone+"','"+password+"') where STD_GR='"+gr+"'"); %>
You cannot use the WHERE clause in an INSERT statement, and you needn't put a bracket '(' after SET in the a UPDATE statment.