By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| id | product_name |
|---|---|
| p1 | apple |
| p2 | apple |
| p3 | grape |
| p4 | grape |
| p5 | grape |
SELECT 5
UPDATE 5
| id | product_name |
|---|---|
| p1 | apple |
| p1 | apple |
| p3 | grape |
| p3 | grape |
| p3 | grape |
SELECT 5