Why am I getting this syntax-error while trying to update a attribute using mysql-query?

Hmm.... I'm thinking that you really want to set the password for each user (I think), in which case you'll need to have a join for the update, and that way you can eliminate your multiple values you are selecting.. because the way you have it, you're updating all the values in the Goal table for pwd to the same value... the way below, you update each users pwd to be based on the row joined with the ID. Assuming you have one row for each usr in the esubmission table, this should work: UPDATE Goal SET pwd = MD5(CONCAT(ID, LEFT(e. Phone,3), '$=')) FROM Goal g, Esubmission e where e.ID = g.usr.

I still get error. And I also tried like UPDATE Goal SET pwd = MD5(CONCAT(g. Usr, LEFT(g.

Phone,3), '$=')) FROM Goal g to generated md5 hash using Goal table itself. – malay May 16 at 0:37 Is it because the ID field is numeric? The CONCAT functions I believe requires all string....(even though it is supposed to implicitly cast it) – M.R.May 16 at 0:43 Also, you don't need 'FROM goal' in the test you tried: in order to do just what you tried, it would be: UPDATE Goal SET pwd = MD5(CONCAT(g.

Usr, LEFT(g. Phone,3), '$=')) – M.R.May 16 at 0:45 Finally it is working now. Thank you so much!

– .

Mine is V. 5.1.54, can you please explain me how you actually did it? – malay May 15 at 23:46 1 @malay : He probably has just 1(or 0) row in ` Esubmission` table – a1ex07 May 15 at 23:49 If I try to update pwd from same table informations like this : UPDATE Goal SET pwd = (SELECT MD5(CONCAT(ID, '$=')) FROM Goal); I still get error!

:( – .

Hmm.... I'm thinking that you really want to set the password for each user (I think), in which case you'll need to have a join for the update, and that way you can eliminate your multiple values you are selecting.. because the way you have it, you're updating all the values in the Goal table for pwd to the same value... the way below, you update each users pwd to be based on the row joined with the ID. Assuming you have one row for each usr in the esubmission table, this should work.

I tested it here and worked fine. MySQL 5.1.37.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.