MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: need simplified update query
Posted by: bruno matthys
Date: March 25, 2005 02:17PM

UPDATE tablename WHERE res_id1 = 2 OR res_id2 = 2 OR res_id3 = 2 SET (CASE 2 WHEN res_id1 THEN 0 WHEN res_id2 THEN 0 WHEN res_id3 THEN 0 END CASE) DB Error: syntax error

I'm not sure this is how it should be ..

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
need simplified update query
bruno matthys
March 25, 2005 05:02AM
Re: need simplified update query
Neal Schilling
March 25, 2005 08:16AM
Re: need simplified update query
bruno matthys
March 25, 2005 01:19PM
Re: need simplified update query
bruno matthys
March 25, 2005 01:20PM
Re: need simplified update query
bruno matthys
March 25, 2005 02:17PM
Re: need simplified update query
Chris Stubben
March 25, 2005 02:34PM
Re: need simplified update query
bruno matthys
March 25, 2005 02:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.