MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Help me please....
Posted by: Monika Klingele
Date: March 21, 2005 09:23AM

Hi,

UPDATE TABLE products_attributes
SET options_values_price=1
WHERE options_values_id >= 7 AND options_values_id <= 180

(instead of this last line you can also use the BETWEEN statement, that's shorter).

Should work this way,

Monika

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


Subject
Written By
Posted
Help me please....
Max Tech
March 20, 2005 11:09PM
Re: Help me please....
Monika Klingele
March 21, 2005 09:23AM
Re: Help me please....
Max Tech
March 21, 2005 06:16PM


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.