How to Update a column in MySQL
To update rows that match a certain condition.–For Example, This will update only one row that matches product_id=1
UPDATE products SET stocks=100, available=true
WHERE product_id=1;
--For Example, This will update multiple rows that match Category='Electronics'
UPDATE products SET stocks=50, available=true
WHERE category='Electronics';To update all rows in a MySQL table, just use the UPDATE statement without a WHERE clause:
UPDATE products SET stocks=100;
