MySql field data changes

[notset4life]

I have a MySQL table, let's call it PRICE. The Price for ALL products in the database is $5.99.
I need to change the price to $4.99 for all records.

Can someone give me the MySql command to do that. I knew at one time but forgot, something like set price = ....etc.

Thanks

[HalfaBee]

I think the sql you are looking for is

update PRICE set price=4.99

This will change the field price in table PRICE for all entries.

Hope this jogs your memory :)

HalfaBee

[notset4life]

Originally posted by HalfaBee
I think the sql you are looking for is

update PRICE set price=4.99

This will change the field price in table PRICE for all entries.

Hope this jogs your memory :)

HalfaBee



Thanks :)