mysql help

[mally]

I've got a mysql database running a shop with oscommerce.

Can any explain how to replace a value in a field (postage weight) for every product.

It looks like when I last added a datafeed I forgot to put and wieght so its stuck with the default of 0.00 which doesn't get charged any postage.

any help appreciated

 

[monaghan]

UPDATE tablename
SET fieldname = new value
[, field2 = new value]
[WHERE any fieldname = filter value]

The where is optional, but if you don't specify will update the whole table.

If you're not sure, take a backup first

 

[aquanuke]

Your host probs has phpmyadmin installed. Which is a simple gui to manage mysql. If not you can d/l it free and install it. Will allow you to do the above in a simple click and do enviroment.

 

[purg]

UPDATE tablename
SET fieldname = new value
[, field2 = new value]
[WHERE any fieldname = filter value]

Personally if your not sure first create SELECT statement so you can see what will be changed. Then do as monaghan said and UPDATE

Just dont forget its a one way process, once updated you cant undo (unless you have a backup)

 

[mally]

great stuff, done the above and it worked, thanks!