I would like to know the answer too. Anyone here know what is the right answer. I'll do some research and get back to you if I discover an useful answer. You should email the people at iPage as they probably could help you..
Looks good to me - make a copy of the products table into your existing DB - run the query and if it goes wrong just re-copy the table..
This post has been edited by.
: 09 May 2004, 21:42..
Or is it:.
UPDATE products SET products_discount_1 = '1.0' WHERE products_model_1 >= '1000' AND products_model_1 < 2000;..
John - I did check the syntax and it seemed fine but, like I said, this is a live shop so I didn't want to go editing things without some assurance. I've ran into a previous problem where I was installing a contribution and it took out my entire db. Several hours passed before I was back up. No way I want to go through that again..
Out of curiosity, how do I run the sql code on the database when it is on my hard drive? I'm guessing I have to have mysql installed?.
Thanks for the suggestion. I didn't know I could do this. I made a copy and tested as you suggested and everything went fine. I appreciate the help..
I need to alter a group of entries in the products table. I've never done this before and this is a live shop so I want to be as sure as possible before doing this. Here's the first line of the sql file I plan on using:.
UPDATE products SET products_discount_1 = '1.0' WHERE products_model >= '1000' AND products_model_1 < 2000;.
My intent is to set the products_discount_1 field to 1.0 for all items that have a model number from 1000 to 1999. Does this look like it will work?.
Did you check the mysql.com iPage site for the proper syntax?.
Also, download a copy of the database and then run the sql code on it?.
Or copy the database to another one on the server ,and try it there...