regarding Update syntax of query

[smitaj joshi]

String sql="update registration set phoneno=" + phone1 + ","+ "emailid=" + emailid1 + " where name="+name1;
System.out.println(sql);
stmt=con.prepareStatement(sql);
stmt.executeUpdate()
stmt.close();
con.close();
ouput of sql-> update registration set phoneno=9860878112,emailid=[e-mail] where name=smita


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[e-mail]'.

[Dany Mendez]

Hello smitaj joshi,

I dont't work with that DBMS, I use oracle, so this is a suggestion.

I can see that you do not limit the strings, could that be the problem?
Like so,
update registration set phoneno=9860878112,emailid='[e-mail]' where name='smita'

Regards