Membership is FREE – with unlimited access to all features, tools, and discussions. Premium accounts get benefits like banner ads and newsletter exposure. ✅ Signature links are now free for all. 🚫 No AI-generated (LLM) posts allowed. Share your own thoughts and experience — accounts may be terminated for violations.

mysql help

Status
Not open for further replies.
Joined
Mar 13, 2006
Posts
2,263
Reaction score
30
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
 
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 :)
 
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.
 
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)
 
Status
Not open for further replies.

Rule #1: Be Respectful

Do not insult any other member. Be polite and do business. Thank you!

Premium Members

New Threads

Domain Forum Friends

Lastest Listings

Our Mods' Businesses

*the exceptional businesses of our esteemed moderators
General chit-chat
Help Users
  • No one is chatting at the moment.
  • Siusaidh AcornBot:
    Siusaidh has left the room.
      Siusaidh AcornBot: Siusaidh has left the room.
      Top Bottom