Databases Modifying Data with SQL Updating Data in a Database Updating Data With SQL

Modifying sql data

We have an eCommerce database and it has a products table. It has the columns id, name, description and price. The warehouse is closing down. There's a clearance sale and all products need to be priced 0.99.

1 Answer

Steven Parker
Steven Parker
182,603 Points

It looks like you just quoted the instructions here, it's not clear what kind of issue you are having.

But here's a generic hint: an UPDATE query that has no filter (no WHERE clause) will act on every record of the table.

If that's not what you needed, please ask a specific question.